

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `iam_account`
-- ----------------------------
DROP TABLE IF EXISTS `iam_account`;
CREATE TABLE `iam_account` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `userId` varchar(32) NOT NULL COMMENT '基础用户Id 对应iam_user.id',
  `userType` varchar(20) DEFAULT 'iam' COMMENT '用户类型 iam内部用户 wechat微信 ding钉钉 qq',
  `authType` varchar(100) DEFAULT 'pwd' COMMENT '登录类型 pwd tps',
  `authAccount` varchar(100) DEFAULT '' COMMENT '登录账号(手机号) / 第三方登录Id',
  `authSecret` varchar(100) DEFAULT '' COMMENT '登录密码',
  `authSalt` varchar(10) DEFAULT '' COMMENT '登录密码混淆',
  `openId` varchar(100) DEFAULT '' COMMENT '第三方登录 openId',
  `unionId` varchar(100) DEFAULT '' COMMENT '第三方unionId',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 2冻结 1启用 0禁用',
  `realName` varchar(100) DEFAULT '' COMMENT '真实姓名',
  `gender` varchar(2) DEFAULT '' COMMENT '性别 男 女',
  `email` varchar(100) DEFAULT '' COMMENT '电子邮箱',
  `ext` mediumtext COMMENT '扩展数据',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`),
  KEY `userType` (`userType`),
  KEY `authType` (`authType`),
  KEY `unionId` (`unionId`),
  KEY `realName` (`realName`),
  KEY `authAccount` (`authAccount`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录账户';

-- ----------------------------
--  Records of `iam_account`
-- ----------------------------
BEGIN;
INSERT INTO `iam_account` VALUES ('123', 'a2869d22ba004ee3be09843f4695c59b', 'tps', 'wx', '13132132', '', '', '1231313', '', '1', '123113', '23', '', null, '', '0', '0', '2020-03-21 10:58:00', '2020-03-21 11:45:17'), ('7a735977787673fae84b5bc2286f1078', '1715e76956b14be6b35f22cf5a2861fe', 'iam', 'pwd', '123', 'ebecbbf8078c5fc1d0e69f5a9e14ce9a', '937256', '', '', '1', '113123333', '保密', '', null, '', '0', '0', '2020-03-19 16:12:22', '2020-03-21 11:45:16'), ('dff190c462193c80cfb4a31df8850226', 'a2869d22ba004ee3be09843f4695c59b', 'iam', 'pwd', '18154579950', '6e7b2d97b7b09186584a91b39a06e241', '451103', '', '', '1', 'Taller', '女', '123', null, '', '0', '0', '2020-02-25 10:44:47', '2020-03-21 10:57:06');
COMMIT;

-- ----------------------------
--  Table structure for `iam_application`
-- ----------------------------
DROP TABLE IF EXISTS `iam_application`;
CREATE TABLE `iam_application` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `code` varchar(100) DEFAULT '' COMMENT '编码',
  `name` varchar(100) DEFAULT '' COMMENT '应用名称',
  `accessKey` varchar(200) DEFAULT '' COMMENT '密钥',
  `accessSecret` varchar(200) DEFAULT '' COMMENT '密匙',
  `panel` varchar(200) DEFAULT '' COMMENT '首页面板',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 1启用 0禁用',
  `icon` varchar(200) DEFAULT '' COMMENT '图标',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用';

-- ----------------------------
--  Records of `iam_application`
-- ----------------------------
BEGIN;
INSERT INTO `iam_application` VALUES ('5b49a8581c9ca148aec74fd49cba1e02', 'suber-system', '运维管理平台', '2002201627790654332928', '221ac08fd3e54bdcae1344122c782809', '/panel/system', '1', '/assets/images/logo.png', '核心系统禁止禁用或删除', '0', '0', '2020-02-20 16:27:18', '2020-02-20 16:27:18');
COMMIT;

-- ----------------------------
--  Table structure for `iam_application_permission`
-- ----------------------------
DROP TABLE IF EXISTS `iam_application_permission`;
CREATE TABLE `iam_application_permission` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `permissionId` varchar(32) NOT NULL COMMENT '权限Id 对应iam_permission.id',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `permissionId` (`permissionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用与权限中间表';

-- ----------------------------
--  Records of `iam_application_permission`
-- ----------------------------
BEGIN;
INSERT INTO `iam_application_permission` VALUES ('067c7fdc3b26e1da6cb69f6bb31dfae8', '0d479f38aa5a002adba1fe9d67d1664a', '9b3737325cfe71bd7dbad14e7e9e2a94', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('06d74dfabb40de1a6bdaa95eb9a889a5', 'f2e5f0598978c156186d705a1f27472e', '968013a6233fb4671f394118118404dc', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('0783d280e01be208d6133601b137c46e', '5b49a8581c9ca148aec74fd49cba1e02', 'e358c148cc2a80b6bb09d26182337b45', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('085e94bfb41a0bc50f292893a5533e3f', '5b49a8581c9ca148aec74fd49cba1e02', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('08b8c4a0acf9acf0f840af0cf3084471', 'f2e5f0598978c156186d705a1f27472e', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('0c018bcf4ed7eecb47a38ea18c8ae585', 'f2e5f0598978c156186d705a1f27472e', '6d1fdcb4e5a280047b928e39a20d48ce', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('0c32cb48957c133594426af63335226f', '180458fa6deb56075de51d4d7354571b', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-03-20 13:58:13', '2020-03-20 13:58:13'), ('0dce42e59ca1e03d57d0c6583121dc0d', '5b49a8581c9ca148aec74fd49cba1e02', '27dd1dc192777934d252afc03befeeaf', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('0dffe623ecf61d70d896c033c159f7d1', 'a0ee0c06a24656d8157ddead6ce0f83d', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('0e44d0fcad54964fa7da161854bd7c57', '892d41b054334bb5087733f0f5bbcddf', 'a3e8e8bcd783f2ac1f21c70b8ecdcce6', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('0f6620c56666ccffa1039a3189d92d72', '892d41b054334bb5087733f0f5bbcddf', '08cb3a3bc1e800e39f12c24004bccf7b', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('1148a76e2522b793975cb0744c9b7395', 'f2e5f0598978c156186d705a1f27472e', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('11bff619cb8bdd8ecfbe936589e4ac53', 'f2e5f0598978c156186d705a1f27472e', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('12380ff6a9a19b15fdacf4594a513dd4', '5b49a8581c9ca148aec74fd49cba1e02', 'a3e8e8bcd783f2ac1f21c70b8ecdcce6', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('16248f531f4851d44dc7400cf8603e50', '5b49a8581c9ca148aec74fd49cba1e02', 'b59886149928772b8a0e7d1760d30c1c', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('17b858a47f7f09e20b1024cbc4cc69b7', '456c0f7a31a9795c3910e2993368d1b4', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('17bd99200e4d3c2bfb397c610a76eec1', '892d41b054334bb5087733f0f5bbcddf', 'e537fbc41e03f053971a038990a13d6a', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('1ade478f1d72ea3f455f529cbc81178d', '5b49a8581c9ca148aec74fd49cba1e02', 'a6a782e8aafd75b3e4404598f47ba328', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('1c0f7e5362f2c7e35b592e5284ec267f', 'a0ee0c06a24656d8157ddead6ce0f83d', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('1c62451aebb8318a9226fb866a2211a0', '5b49a8581c9ca148aec74fd49cba1e02', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('1cff8a2c7075a03696d1d5ba09538dae', 'f2e5f0598978c156186d705a1f27472e', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('1d9a42445a2501260432ebcc6c19b2e6', 'f2e5f0598978c156186d705a1f27472e', '71370173a20f5ae12611d5f1063480a3', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('1e4dbedf3b52c2b30b071ff8e83b937b', '5b49a8581c9ca148aec74fd49cba1e02', '86273c0cd39b57e65596405c10d24f09', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('1fd7e02b679db9226d8820c102f0baf4', '456c0f7a31a9795c3910e2993368d1b4', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('20cd0d28114236cea733657b953fbe09', '5b49a8581c9ca148aec74fd49cba1e02', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('23ab2400496e7ab16582169f08434c25', '5b49a8581c9ca148aec74fd49cba1e02', 'e9597ceb48f7b56d3555aa3fcad88641', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('23c7c9a4f477bec094e75b5249462ebc', '5b49a8581c9ca148aec74fd49cba1e02', '0e45fd8762de8b64b319ae1148aa4ce7', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('24693a7874db83cfcf6bf34006250f19', '5b49a8581c9ca148aec74fd49cba1e02', '7afe02054c20fd96e566e60463377702', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('24d36640100520e302cc43dbb94c9bba', '5b49a8581c9ca148aec74fd49cba1e02', '742e28369bf88c8e9958e4b7a9bac633', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('26b419f4de43cfc9d30b9b5108df7a0d', '892d41b054334bb5087733f0f5bbcddf', '22d799956ff262d2bc45af6e6e059175', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('2b52943c8fe96a09cf012b6a03af9e7b', 'f2e5f0598978c156186d705a1f27472e', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('2ce669dbd80bfcb02865ef3e9b67d2d8', '892d41b054334bb5087733f0f5bbcddf', '60f0795af032f6800857416e756ec616', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('2e7ccccc4b913474ebff2838a56f6def', '5b49a8581c9ca148aec74fd49cba1e02', '4017245ead01c7d4ee89ddddd09df077', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('30de299f66c1782c1ec255be81935031', 'a0ee0c06a24656d8157ddead6ce0f83d', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('30e5e7039fad8b22671aca5e3032c5fc', '5b49a8581c9ca148aec74fd49cba1e02', '2ceb5a25c2f88a846a5f8208f7a63b49', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('333f366ad800dbd5175c22c2feda1684', 'f2e5f0598978c156186d705a1f27472e', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('33f61fa741322484d6d38e35146bd48c', '892d41b054334bb5087733f0f5bbcddf', 'e5c58fc1323aad12be483124bc9963ab', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('3512ebc335a7d8377b84d20d4511cafb', 'f2e5f0598978c156186d705a1f27472e', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('372a7b9a76c4ab1778d5ef5c08c3c2c4', '892d41b054334bb5087733f0f5bbcddf', '64065c89e58a4be6a7fa8f561f6fc270', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('3899a8f15f653a4beeac4763c3378c98', 'a0ee0c06a24656d8157ddead6ce0f83d', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('38ee9210d3047df5f01d7d8f3bbadaf0', 'f2e5f0598978c156186d705a1f27472e', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('3a9ecec85532b9343d1928377bca60cb', 'a0ee0c06a24656d8157ddead6ce0f83d', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('3ca6cf4a5801b436f6a3411218c2847f', '892d41b054334bb5087733f0f5bbcddf', '5cb2faaf199952e5d34d71d7ee3a45b2', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('3f23384b5b0542a73b6a0230a1eb24fc', '456c0f7a31a9795c3910e2993368d1b4', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('422c5e576a98b7adc6682ffe4959110b', 'f2e5f0598978c156186d705a1f27472e', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('4455dd94c98a65259b56f44404f73025', '180458fa6deb56075de51d4d7354571b', 'bfbf3de126f8daf113b2c8d07eb68fc6', '0', '0', '2020-03-20 13:58:13', '2020-03-20 13:58:13'), ('455ecda048ae1e43a3ee571e4e79f855', '5b49a8581c9ca148aec74fd49cba1e02', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('47ee8c07abf463be9694072c29173409', '5b49a8581c9ca148aec74fd49cba1e02', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('48954b6a43dba8e2b9e66e9708b0e413', '5b49a8581c9ca148aec74fd49cba1e02', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('48f2fa66109174e7ebf58f9d1037362e', 'f2e5f0598978c156186d705a1f27472e', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('49530c7a8f2460dc98f3dbb456035766', '456c0f7a31a9795c3910e2993368d1b4', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('4bbc1f5ebdbd95f74bd81d4ccc2721bf', '456c0f7a31a9795c3910e2993368d1b4', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('4c34a09c5cfd343760d0b82e7094aff4', 'a0ee0c06a24656d8157ddead6ce0f83d', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('4d749dc0a554e9d3287a1f63dd7cf1ea', 'f2e5f0598978c156186d705a1f27472e', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('50b9b95062110624bdda36117457d264', '5b49a8581c9ca148aec74fd49cba1e02', 'a988bf4d65a375544ae440bc17c40977', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('51988e6401cac4f8b90e40fc0c385e40', '892d41b054334bb5087733f0f5bbcddf', '4018f9e5db9c332d81328689a40e0ceb', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('53209a58a4793ffa8c8a76248b6f29e5', '5b49a8581c9ca148aec74fd49cba1e02', 'bfbf3de126f8daf113b2c8d07eb68fc6', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('53ba45a392138dcca697ed44395a68e4', 'f2e5f0598978c156186d705a1f27472e', 'e2adc597bd000a235c30389279b2b2c1', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('554b6955f220fbef1896e4913f2a4424', 'f2e5f0598978c156186d705a1f27472e', 'a01eb3e48b22a0ad314af5f2e281ea01', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('5c647c143e5f327abe8585c38333a855', '892d41b054334bb5087733f0f5bbcddf', '732af14c7ed76bb45720bc0015a0a28b', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('5e965cc1591257ec13f6193ca61c96ed', '456c0f7a31a9795c3910e2993368d1b4', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('616499b928563753a3283cdc431f410f', 'a0ee0c06a24656d8157ddead6ce0f83d', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('660ed797d9f2ef26bcbb363c048b5411', '5b49a8581c9ca148aec74fd49cba1e02', 'e537fbc41e03f053971a038990a13d6a', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('6645c66ae3bcdbbd04726cfc91b3eaa9', '5b49a8581c9ca148aec74fd49cba1e02', '2c982ea5305662a14d2c0ff9d0efd428', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('680f2cbe6a7362cb6e73cd3aa7820a0b', '5b49a8581c9ca148aec74fd49cba1e02', '08cb3a3bc1e800e39f12c24004bccf7b', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('68643eb433d4ca6a3597feefa5610612', '5b49a8581c9ca148aec74fd49cba1e02', 'ce6f72ccb33c94e58349755bd67fdb7d', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('695ad42873b868f3bc422c9106759d7f', 'd95d698c118bece1e2acb9810566d3a1', 'd3fb22faf6a00cc4f947be415b5668d2', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('6b24dd8349f328e987750886be93b7c9', '0d479f38aa5a002adba1fe9d67d1664a', '2751d8d56e2aaf48e93c9d87663890c8', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('6c2084ab051d080a51ac7e625a0f8c56', '5b49a8581c9ca148aec74fd49cba1e02', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('6e8e4852b70128bbec347db92d8d8495', '892d41b054334bb5087733f0f5bbcddf', 'e9597ceb48f7b56d3555aa3fcad88641', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('6ec3ce0c5223e18b98abfa136ddb21b7', '0d479f38aa5a002adba1fe9d67d1664a', '26b84cab56288f61df44ba60769a2320', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('71627e6ab9bebaa627361ff2ddce0ed3', '5b49a8581c9ca148aec74fd49cba1e02', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('71754455cd6c689084c7a84c3913aa17', '5b49a8581c9ca148aec74fd49cba1e02', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('7247758909448856171b9042014e8562', '456c0f7a31a9795c3910e2993368d1b4', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('724afe2ab517f4643ba4d8a741622868', 'd95d698c118bece1e2acb9810566d3a1', '644b31d5f09a9094828deb332bb17403', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('727baf9cc89601e9978cc3e6324f8b10', 'f2e5f0598978c156186d705a1f27472e', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('72cdc7a6344a6d46f7ba783644f6ea9d', '5b49a8581c9ca148aec74fd49cba1e02', '0cfa00db49a08d7891da4d593db4fb77', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('73e683bc7ad369218d09d505a5fe2c7a', '456c0f7a31a9795c3910e2993368d1b4', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('7502d8e92cb66107bb8a786bd2dc6f23', '0d479f38aa5a002adba1fe9d67d1664a', '3c2f9b0ea0137b43d07e658ac01b69f7', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('7692342864d2fa11b54a3e8a04b4b35b', '5b49a8581c9ca148aec74fd49cba1e02', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('78e789f4a181ac1e1201e9e4441ea4d0', '5b49a8581c9ca148aec74fd49cba1e02', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('7ac142b4d35454b8566ae44d4d7df150', '892d41b054334bb5087733f0f5bbcddf', 'bfbf3de126f8daf113b2c8d07eb68fc6', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('7af180562e4fc86f008d038071906857', 'd95d698c118bece1e2acb9810566d3a1', '7ca3d7cc1f21bd6bec540764b5a110b5', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('7b2a43e7e7464658f96f08113d091224', 'f2e5f0598978c156186d705a1f27472e', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('7de8826bf188f38b7c995c93135b8b89', 'd95d698c118bece1e2acb9810566d3a1', 'fe1de3fe9686091a5850501ba83fa0b7', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('7e5926b5fc374359b237dab0eccebac5', 'f2e5f0598978c156186d705a1f27472e', '449ef06381142afb6332ad9c94cf5113', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('7e70d00f2ac9a0a288937f87ddc3dd20', 'f2e5f0598978c156186d705a1f27472e', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('7fb4e89b5004e97754d1a4894a79e03d', '5b49a8581c9ca148aec74fd49cba1e02', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('81425c40d87e1c1891edf5b1aa7e9313', 'f2e5f0598978c156186d705a1f27472e', 'ec27bc22a9ea475cd0a5da4d46607716', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('833eb0d063134271ad5ef8eab409e194', 'a0ee0c06a24656d8157ddead6ce0f83d', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('843d166ff5004a5346d5dbaa8ab68529', '892d41b054334bb5087733f0f5bbcddf', '888483cf88e186ee28b70a8105dd9ceb', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('855edeead6a8d5683136d428a9540ccf', 'f2e5f0598978c156186d705a1f27472e', 'becc642f531d740aed23bcb58060e43a', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('865aef425fec1e6855fa2f752257247d', 'f2e5f0598978c156186d705a1f27472e', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('869df29ec6ca28dd03ad70acebae0ccf', 'a0ee0c06a24656d8157ddead6ce0f83d', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('86bdee962a7b53d83ae51b93e7129383', '892d41b054334bb5087733f0f5bbcddf', '0b343f2a6357687afcb2688e6c4a31fc', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('89adb2e10bba44d6d60df587ddda51ff', '5b49a8581c9ca148aec74fd49cba1e02', 'e0b79d2aef0d1602a82b6c42b381c754', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('89b6f41733692513a26e86760ab771ae', '892d41b054334bb5087733f0f5bbcddf', 'a6a782e8aafd75b3e4404598f47ba328', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('8b42cebf0cc9827a11d1b0788a7bac6e', '5b49a8581c9ca148aec74fd49cba1e02', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('8bc58d58a1bf3db7e45735a089a4b5dc', '456c0f7a31a9795c3910e2993368d1b4', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('8d29e1ec831851acfd9a2c6607a9f36b', '892d41b054334bb5087733f0f5bbcddf', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('8fe6d3a3a01b6ad2047df006fcec5c28', 'f2e5f0598978c156186d705a1f27472e', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('8ffb2e623d5a57730a2ff64ed46e7236', '5b49a8581c9ca148aec74fd49cba1e02', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('92b903d792fe11bd37fc9e4db4b63f83', '5b49a8581c9ca148aec74fd49cba1e02', '8ad247625f7be483de304faf97b294ef', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('943361fd08c170729a564bf33664aeed', '5b49a8581c9ca148aec74fd49cba1e02', '4bf3a08b53fc66d73ac5460a18c32ee0', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('95292b3eb4eca56328e6550b500ce538', 'f2e5f0598978c156186d705a1f27472e', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('97a3a6c60b32c2688111a207afc9f0af', '5b49a8581c9ca148aec74fd49cba1e02', '17eb6f7b98ecbc8449c841eafe91ef0a', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('982f7306d895a0761981cc239869b921', '456c0f7a31a9795c3910e2993368d1b4', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('985be806657d28364679641711eafbf1', '456c0f7a31a9795c3910e2993368d1b4', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('99ee87e63615ea28a1695fdc5ebd32dc', 'a0ee0c06a24656d8157ddead6ce0f83d', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('9ab69c8595c531eb0530b215d7ea0a13', '5b49a8581c9ca148aec74fd49cba1e02', '4018f9e5db9c332d81328689a40e0ceb', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('9e5d8abcb1a66043cff77275a8dd1a9d', 'a0ee0c06a24656d8157ddead6ce0f83d', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('9f3e2f8feaf36ebc336e42c69430773c', '0d479f38aa5a002adba1fe9d67d1664a', '6f04f5b13c3e48f49dcbf1028fbfe501', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('a19f610a710fff22c6b26c42de338630', '5b49a8581c9ca148aec74fd49cba1e02', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('a20915d6c14a01e8fc9e140079fa73a6', 'f2e5f0598978c156186d705a1f27472e', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('a231a48863ec123eb8e6bc0c623b57e7', '892d41b054334bb5087733f0f5bbcddf', '2ceb5a25c2f88a846a5f8208f7a63b49', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('a2c4c41a580d18b902d03df012a3cd4d', '5b49a8581c9ca148aec74fd49cba1e02', 'e5c58fc1323aad12be483124bc9963ab', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('a4c5f1632365d1156d0867b26931a47f', '180458fa6deb56075de51d4d7354571b', 'a3e8e8bcd783f2ac1f21c70b8ecdcce6', '0', '0', '2020-03-20 13:58:13', '2020-03-20 13:58:13'), ('a54503d4f0f5edb178dd05bc83299e57', 'a0ee0c06a24656d8157ddead6ce0f83d', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('a63db64ec8613ae938639bb804c272ed', '5b49a8581c9ca148aec74fd49cba1e02', '22d799956ff262d2bc45af6e6e059175', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('a6ca54a5f32271096ee888c5b2f342f0', 'a0ee0c06a24656d8157ddead6ce0f83d', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('a79a8ea19a219c369f20d90505b04034', '5b49a8581c9ca148aec74fd49cba1e02', '434105e39f46eb24672f5a61fb35ec2d', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('a7fbbf116ed8968ff29a3819bdc777c5', '5b49a8581c9ca148aec74fd49cba1e02', 'f05436bbe73a07dc513684cfa30d6134', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('a91169c20868d2390e4c11ad9f4086b1', 'f2e5f0598978c156186d705a1f27472e', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('aac413e39e68912f4ede599c51d797cb', 'f2e5f0598978c156186d705a1f27472e', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('aeed50e3a4620d7f3ef6201b880bfa3f', '5b49a8581c9ca148aec74fd49cba1e02', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('b2f0a1d90a7e24f903dd697f011ef962', '892d41b054334bb5087733f0f5bbcddf', 'cfb979193a2a81a7ec5b34a0dc62b4e4', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('b38ccadc0905fa76fd037b0e96f122c8', 'f2e5f0598978c156186d705a1f27472e', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('b5ac9f0eeece1200ef3d430eb23e6c8d', 'f2e5f0598978c156186d705a1f27472e', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('b64361c6b9f31f65c346ebdc4763c218', '892d41b054334bb5087733f0f5bbcddf', '26577e5df76827a465280cec7f865031', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('b8c10dd54bc4c3f25541d0871ddf604a', '456c0f7a31a9795c3910e2993368d1b4', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('b97283a2f301116a1d3d780634fd1fda', '180458fa6deb56075de51d4d7354571b', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-03-20 13:58:13', '2020-03-20 13:58:13'), ('bb5588fd09997ec050040232f25d292d', '892d41b054334bb5087733f0f5bbcddf', 'e358c148cc2a80b6bb09d26182337b45', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('be4aaa20a79d2098866fc390039686fd', '0d479f38aa5a002adba1fe9d67d1664a', '00eaf40db2751e1785ddc1e515666ec5', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('bfbfcb856cb5fd586212179c0de4f577', '456c0f7a31a9795c3910e2993368d1b4', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('bffabc03f9c9a9f7452bdeba2eab56d8', '5b49a8581c9ca148aec74fd49cba1e02', 'cfb979193a2a81a7ec5b34a0dc62b4e4', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('bffb49e64222360e30e45dcfb25cb9c2', 'a0ee0c06a24656d8157ddead6ce0f83d', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('c103be368ed8aee7d11d0d2c2a0e5218', 'f2e5f0598978c156186d705a1f27472e', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('c3bef79f92e7997b4a4bd7ea39dedd6c', '892d41b054334bb5087733f0f5bbcddf', '13ad79fc9659786981ff7ad219a32862', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('c5f1b56d7ba645e58aa9d6c1fd150ac9', '5b49a8581c9ca148aec74fd49cba1e02', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('c63abe1c285ff163a86cfe7f191a4629', '0d479f38aa5a002adba1fe9d67d1664a', '882df389e451aeba3ffdaef7b22105df', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('c64bce7448f6e5fce6e4581ecd33dbc5', 'f2e5f0598978c156186d705a1f27472e', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('c6fbf388e849d8ac14a6ea4e32cfc529', 'f2e5f0598978c156186d705a1f27472e', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('cbf234161ffd104af918b9f6aef44baf', 'a0ee0c06a24656d8157ddead6ce0f83d', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('cc5ea9b58c73323637208cd62ca2e3cc', '5b49a8581c9ca148aec74fd49cba1e02', '0b343f2a6357687afcb2688e6c4a31fc', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('cde9f3d719dfea11a77c1d744e5d0991', '5b49a8581c9ca148aec74fd49cba1e02', '60f0795af032f6800857416e756ec616', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('ce0aef8eadea6c41711b5ae83966224c', '892d41b054334bb5087733f0f5bbcddf', '19e4a1770fbcc10f281f933f14f6bd49', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('cf1fd856ccc879542a83c5e8a2515bd2', 'f2e5f0598978c156186d705a1f27472e', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('d7c82aadd0f7914214062e6bd6061ad5', '0d479f38aa5a002adba1fe9d67d1664a', '40542a45e97b766e9c1ab23e337f5ec9', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('d931fccc719f4386a00fd91b2e9c42da', '5b49a8581c9ca148aec74fd49cba1e02', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('dc55d58a6ea1eead40373bd68304edab', '892d41b054334bb5087733f0f5bbcddf', 'ce6f72ccb33c94e58349755bd67fdb7d', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('e0c58be303386d0f7c7284a0e2bdde20', 'f2e5f0598978c156186d705a1f27472e', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('e12e3f4c9fdbd91f77a65716788b92c9', '456c0f7a31a9795c3910e2993368d1b4', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('e18c749f843088f6b4cbbd424ba50f6b', '5b49a8581c9ca148aec74fd49cba1e02', '5cb2faaf199952e5d34d71d7ee3a45b2', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('e30769fbc0067c94e0ba97c32d63cc52', '892d41b054334bb5087733f0f5bbcddf', '5e93210da42bb819d7d6a6c6e4f03f27', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('e4259836db8c2924bace2bb893583f7b', '892d41b054334bb5087733f0f5bbcddf', '66824fe3a127acfbf805149d0c917c3d', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('e49ad8e65cbcda892fa29d991a7c864c', '456c0f7a31a9795c3910e2993368d1b4', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('e61f789bf0f2002f274a2f0dd8dae7e0', '892d41b054334bb5087733f0f5bbcddf', '8ad247625f7be483de304faf97b294ef', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('e6d768412257feb5ae50d8d2af25db84', '5b49a8581c9ca148aec74fd49cba1e02', '64065c89e58a4be6a7fa8f561f6fc270', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('e86028c757cd839fe544d67b6940584f', 'a0ee0c06a24656d8157ddead6ce0f83d', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26'), ('eaa81fc90df21d283e5b4bb388a0ad52', '892d41b054334bb5087733f0f5bbcddf', 'a988bf4d65a375544ae440bc17c40977', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('eaabe9bd7cc310892e5d6a84911c957f', '892d41b054334bb5087733f0f5bbcddf', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('eac4ce38addec2a6491292c2f4ecf75a', '5b49a8581c9ca148aec74fd49cba1e02', 'f920f519af0dae90e5c8cc38ec11cb8e', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('ecf44407a806d4c0211bfca35dcde038', 'd95d698c118bece1e2acb9810566d3a1', 'dae35adf859aa9d8edce2be5c2a2a4c2', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('edc95fdb54f2f3d717a0468464372152', '5b49a8581c9ca148aec74fd49cba1e02', '26577e5df76827a465280cec7f865031', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('ee439e82bd8a35da7cdd4c6cd416f105', 'd95d698c118bece1e2acb9810566d3a1', '5608a6f820b7f3111f5c2b50e4449376', '0', '0', '2020-03-03 16:16:19', '2020-03-03 16:16:19'), ('ef684d9b9d20544add95910f7ffedfaf', '892d41b054334bb5087733f0f5bbcddf', '901bfe9d7deae327d4e777cf2fe75d67', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('efc7d19a4dd54653b877cb1efc100781', 'f2e5f0598978c156186d705a1f27472e', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('f0a9f633abe93f3649aca5136c9159d1', '0d479f38aa5a002adba1fe9d67d1664a', '1da92ac42b2b0d4f274a1ec9a5aa69fe', '0', '0', '2020-03-03 15:03:02', '2020-03-03 15:03:02'), ('f368c24c34d751d3b3ccb608d2da809b', '456c0f7a31a9795c3910e2993368d1b4', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('f393bfe6900f389dd1cff33ae337f0ab', 'f2e5f0598978c156186d705a1f27472e', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('f46e5d651168d341eb0c364ea47544a9', '892d41b054334bb5087733f0f5bbcddf', '4017245ead01c7d4ee89ddddd09df077', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('f4c2b168c78be2bf65089b80b41e3665', '5b49a8581c9ca148aec74fd49cba1e02', '901bfe9d7deae327d4e777cf2fe75d67', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('fa6d6f86e2ce60f96d00e9eba6941dd6', '892d41b054334bb5087733f0f5bbcddf', '27dd1dc192777934d252afc03befeeaf', '0', '0', '2020-03-19 13:40:29', '2020-03-19 13:40:29'), ('fcb6aa126b26550ec9974a6bb040e3ae', '5b49a8581c9ca148aec74fd49cba1e02', 'aeb31208eb351c4bf916ffae38157abf', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('fdd6eeebe765c40ef12127b35dc62d1d', '5b49a8581c9ca148aec74fd49cba1e02', '9d6ff1ee826823b0ae1d5fb9429b6ca9', '0', '0', '2020-03-31 11:28:02', '2020-03-31 11:28:02'), ('feb1697f3005fa88ff718e7ea1811849', '456c0f7a31a9795c3910e2993368d1b4', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-03 13:59:01', '2020-03-03 13:59:01'), ('feb86b351f7c21b41ac65f6f798a42f7', 'f2e5f0598978c156186d705a1f27472e', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-12 14:57:28', '2020-03-12 14:57:28'), ('fef958851f40edbf2ff7737f31b2f7e9', '5b49a8581c9ca148aec74fd49cba1e02', '5e93210da42bb819d7d6a6c6e4f03f27', '0', '0', '2020-03-31 11:28:01', '2020-03-31 11:28:01'), ('ff173ae1ce4cf69d34db1ffe4acfc81d', 'a0ee0c06a24656d8157ddead6ce0f83d', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-20 13:48:26', '2020-03-20 13:48:26');
COMMIT;

-- ----------------------------
--  Table structure for `iam_department`
-- ----------------------------
DROP TABLE IF EXISTS `iam_department`;
CREATE TABLE `iam_department` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `name` varchar(32) NOT NULL COMMENT '部门名称',
  `parentId` varchar(32) DEFAULT '0' COMMENT '上级部门Id',
  `sortId` int(11) DEFAULT '1' COMMENT '排序 数字越大越靠前',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 1启用 0禁用',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `parentId` (`parentId`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='组织架构';

-- ----------------------------
--  Records of `iam_department`
-- ----------------------------
BEGIN;
INSERT INTO `iam_department` VALUES ('281873a8f7d2e96f91aacd4be6fd3669', '5b49a8581c9ca148aec74fd49cba1e02', 'AAAA1', '0', '999', '1', '1', '0', '2020-03-30 12:41:59', '2020-03-30 12:43:48'), ('6134b529444f6f2e7bbd4b44160275a2', '5b49a8581c9ca148aec74fd49cba1e02', 'AAAA21', '87855c61a1dcbd33547f80d7611c79c7', '0', '1', '1', '0', '2020-03-30 14:57:15', '2020-03-30 14:57:42'), ('87855c61a1dcbd33547f80d7611c79c7', '5b49a8581c9ca148aec74fd49cba1e02', 'AAA1', 'b8cd020f5c75a55df4a201d7d75a1b7e', '0', '1', '0', '0', '2020-03-30 14:57:07', '2020-03-30 14:57:07'), ('a7a7f5d86d48c5779f1c185d02fb25fe', '5b49a8581c9ca148aec74fd49cba1e02', 'AAA3', '87855c61a1dcbd33547f80d7611c79c7', '0', '1', '0', '0', '2020-03-30 14:57:24', '2020-03-30 14:57:24'), ('b8cd020f5c75a55df4a201d7d75a1b7e', '5b49a8581c9ca148aec74fd49cba1e02', 'AAA', '0', '123', '1', '0', '0', '2020-03-30 12:43:53', '2020-03-30 12:43:53');
COMMIT;

-- ----------------------------
--  Table structure for `iam_department_user`
-- ----------------------------
DROP TABLE IF EXISTS `iam_department_user`;
CREATE TABLE `iam_department_user` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `deptId` varchar(32) NOT NULL COMMENT '所属组织id 对应iam_department.id',
  `userId` varchar(32) NOT NULL COMMENT '用户id',
  `type` smallint(1) DEFAULT '1' COMMENT '类型 1基层 2中层 3高层',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `userId` (`userId`),
  KEY `deptId` (`deptId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='组织架构人员关系表';

-- ----------------------------
--  Records of `iam_department_user`
-- ----------------------------
BEGIN;
INSERT INTO `iam_department_user` VALUES ('1', '', '87855c61a1dcbd33547f80d7611c79c7', 'a2869d22ba004ee3be09843f4695c59b', '1', '0', '0', '2020-03-30 15:49:16', '2020-03-30 15:49:16'), ('b061c45d94bdbe0b5a2081d519a6a1aa', '5b49a8581c9ca148aec74fd49cba1e02', 'a7a7f5d86d48c5779f1c185d02fb25fe', 'a2869d22ba004ee3be09843f4695c59b', '1', '1', '0', '2020-03-31 11:31:36', '2020-03-31 11:34:28');
COMMIT;

-- ----------------------------
--  Table structure for `iam_module`
-- ----------------------------
DROP TABLE IF EXISTS `iam_module`;
CREATE TABLE `iam_module` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `name` varchar(50) DEFAULT '' COMMENT '模块名称',
  `code` varchar(50) DEFAULT '' COMMENT '模块编码',
  `sortId` int(11) DEFAULT '1' COMMENT '排序 数字越大越靠前',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 2冻结 1启用 0禁用',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='模块';

-- ----------------------------
--  Records of `iam_module`
-- ----------------------------
BEGIN;
INSERT INTO `iam_module` VALUES ('4a7c57864b2b25e68989979ef5240566', '运维管理模块', 'system-center', '99999', '1', '', '0', '0', '2020-02-20 16:27:58', '2020-02-20 16:29:30'), ('5b6464b1f355116b18a2798cd8243157', '基础配置管理模块', 'module-base-config', '2000', '1', '', '0', '0', '2020-02-24 17:39:16', '2020-03-20 10:20:52');
COMMIT;

-- ----------------------------
--  Table structure for `iam_permission`
-- ----------------------------
DROP TABLE IF EXISTS `iam_permission`;
CREATE TABLE `iam_permission` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `type` varchar(32) DEFAULT 'admin' COMMENT '类型 admin app',
  `moduleId` varchar(32) NOT NULL COMMENT '所属模块id 对应iam_module.id',
  `parentId` varchar(32) DEFAULT '0' COMMENT '所属上级 0为最顶层',
  `name` varchar(50) DEFAULT '' COMMENT '权限名称',
  `uri` varchar(100) DEFAULT '' COMMENT '对应路由',
  `icon` varchar(50) DEFAULT '' COMMENT '菜单图标',
  `flag` varchar(100) DEFAULT '' COMMENT '权限标识',
  `color` varchar(50) DEFAULT '' COMMENT '按钮颜色',
  `event` varchar(50) DEFAULT '' COMMENT '前端事件',
  `position` smallint(1) DEFAULT '1' COMMENT '前端按钮位置 1静默加载 2顶部按钮 3侧边按钮',
  `groups` varchar(10) DEFAULT 'menu' COMMENT 'menu菜单 auth页面权限',
  `sortId` int(11) DEFAULT '1' COMMENT '排序 数字越大越靠前',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 1启用 0禁用',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `moduleId` (`moduleId`),
  KEY `parentId` (`parentId`),
  KEY `groups` (`groups`),
  KEY `name` (`name`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限';

-- ----------------------------
--  Records of `iam_permission`
-- ----------------------------
BEGIN;
INSERT INTO `iam_permission` VALUES ('0080f69c5b5bf4a87eb8866010ae624d', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '表格', '', '', 'iam:role:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-25 11:32:50', '2020-02-25 11:32:50'), ('08cb3a3bc1e800e39f12c24004bccf7b', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '读取权限', '', '', 'iam:app:data:permission', '', 'get_permission', '3', 'auth', '8', '1', '', '0', '0', '2020-02-21 14:24:59', '2020-02-21 14:24:59'), ('0b0f0b2437533e3c85c8b7a8437d1570', 'admin', '8c352f9eabb53e16e45c1088da3c4bbd', '8c352f9eabb53e16e45c1088da3c4bbd', '功能菜单1', '', '', '', '', '', '1', 'menu', '1', '1', '', '0', '0', '2020-03-02 16:24:32', '2020-03-02 16:24:32'), ('0b343f2a6357687afcb2688e6c4a31fc', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '权限', '', '', 'iam:app:opt:permission', '', 'permission', '1', 'auth', '9', '1', '', '0', '0', '2020-02-21 10:15:51', '2020-02-21 14:10:49'), ('0bcfb0abface8cca933d1257c8c94473', 'admin', '79fbe2152b44a45f523db80f7b1511a1', '7e89596dec40c84d0bf865debfb70d0d', '设备中心', '/device/index', '', '', '', '', '1', 'menu', '9', '1', '', '0', '0', '2020-02-24 16:17:27', '2020-02-24 16:17:27'), ('0cd1654eec7853c17ee767b6370dc115', 'admin', '1388aebda127e6d7a37a34c447a33e41', 'dfb405117fb48f39ad23549ab78d04c3', '警员档案', '/alarm/police/index', '', '', '', '', '1', 'menu', '97', '1', '', '0', '0', '2020-02-26 11:52:02', '2020-03-03 00:28:48'), ('0cfa00db49a08d7891da4d593db4fb77', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '设置', '', '', 'iam:department:user:set', '', 'set-user', '3', 'auth', '1', '1', '', '0', '0', '2020-03-31 11:27:31', '2020-03-31 11:27:31'), ('0e45fd8762de8b64b319ae1148aa4ce7', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '角色', '', '', 'iam:role:platform:data:list', '', 'role', '1', 'auth', '10', '1', '', '0', '0', '2020-03-27 13:54:40', '2020-03-27 13:54:40'), ('171fe7c7e717d0755d08745975424686', 'admin', '5b6464b1f355116b18a2798cd8243157', '697958609d3aebf918663485cb4d1b7b', '读取角色', '', '', 'iam:app:role:data:list', '', 'get_role', '3', 'auth', '5', '1', '', '0', '0', '2020-02-25 09:28:07', '2020-02-25 09:28:07'), ('177a965f68712d79bc9722ad24b4396f', 'admin', '5b6464b1f355116b18a2798cd8243157', '697958609d3aebf918663485cb4d1b7b', '删除', '', '', 'iam:account:app:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-02-25 09:24:47', '2020-02-25 10:31:31'), ('17eb6f7b98ecbc8449c841eafe91ef0a', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '编辑', '', '', 'iam:department:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-03-30 12:00:30', '2020-03-30 12:00:30'), ('22d799956ff262d2bc45af6e6e059175', 'admin', '4a7c57864b2b25e68989979ef5240566', '2ceb5a25c2f88a846a5f8208f7a63b49', '创建', '', '', 'iam:module:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-21 14:10:25', '2020-02-21 14:10:25'), ('25785a67e4b1acf052abad917979617a', 'admin', '1388aebda127e6d7a37a34c447a33e41', '89dbb370d84e8b61d735ad3c6eb565f7', '读取学校', '', '', 'alarm:school:data:list:all', '', 'get_school', '3', 'auth', '8', '1', '', '0', '0', '2020-02-26 14:42:48', '2020-02-26 14:42:48'), ('25ef5199dae89bc5191a124c1f128ce5', 'admin', '1388aebda127e6d7a37a34c447a33e41', '89dbb370d84e8b61d735ad3c6eb565f7', '创建', '', '', 'alarm:school:video:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-26 14:41:33', '2020-02-26 14:43:16'), ('26126979d34d0e96f5beffa036e1daca', 'admin', '1388aebda127e6d7a37a34c447a33e41', 'dfb405117fb48f39ad23549ab78d04c3', '学校管理', '/alarm/school/index', '', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-02-26 11:50:47', '2020-02-26 11:54:25'), ('26577e5df76827a465280cec7f865031', 'admin', '4a7c57864b2b25e68989979ef5240566', '5e93210da42bb819d7d6a6c6e4f03f27', '删除', '', '', 'iam:permission:opt:delete', '', 'delete', '1', 'auth', '7', '1', '', '0', '0', '2020-02-21 14:14:16', '2020-02-21 14:14:16'), ('274be732b3904ce997d5830e8c0df3a4', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '读取权限', '', '', 'iam:role:permission:data:list', '', 'get_permission', '3', 'auth', '8', '1', '', '0', '0', '2020-02-25 11:35:11', '2020-02-25 11:35:11'), ('27dd1dc192777934d252afc03befeeaf', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '权限重载', '', '', 'iam:app:data:permission:reload', '', 'reloadPermission', '1', 'auth', '99', '1', '', '0', '0', '2020-03-06 11:27:26', '2020-03-20 13:51:33'), ('2b93fcf0a6612413d3fbac131bbef7b9', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '编辑', '', '', 'alarm:school:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:55:47', '2020-02-26 11:58:34'), ('2c982ea5305662a14d2c0ff9d0efd428', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '删除', '', '', 'iam:department:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-03-30 12:00:30', '2020-03-30 12:00:30'), ('2ceb5a25c2f88a846a5f8208f7a63b49', 'admin', '4a7c57864b2b25e68989979ef5240566', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '模块管理', '/iam/module/index', '', '', '', '', '1', 'menu', '10099', '1', '', '0', '0', '2020-02-21 10:07:53', '2020-02-21 10:08:28'), ('30e466f84d0ef85d933a4c22768cd0d6', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '创建', '', '', 'iam:role:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-25 11:33:14', '2020-02-25 11:33:14'), ('4017245ead01c7d4ee89ddddd09df077', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '降权', '', '', 'iam:user:application:opt:delete', '', 'removeAuth', '3', 'auth', '5', '1', '', '0', '0', '2020-02-23 18:18:51', '2020-03-18 10:09:15'), ('4018f9e5db9c332d81328689a40e0ceb', 'admin', '4a7c57864b2b25e68989979ef5240566', '2ceb5a25c2f88a846a5f8208f7a63b49', '表格', '', '', 'iam:module:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-21 10:17:30', '2020-02-21 14:10:35'), ('434105e39f46eb24672f5a61fb35ec2d', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '创建', '', '', 'iam:department:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-03-30 12:00:30', '2020-03-30 12:00:30'), ('449ef06381142afb6332ad9c94cf5113', 'admin', '1388aebda127e6d7a37a34c447a33e41', '0cd1654eec7853c17ee767b6370dc115', '创建', '', '', 'alarm:police:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:57:35', '2020-03-03 15:38:39'), ('46ee24a950e34bc3c42835e8e0305030', 'admin', '5b6464b1f355116b18a2798cd8243157', '697958609d3aebf918663485cb4d1b7b', '编辑', '', '', 'iam:account:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-02-25 09:24:16', '2020-02-25 09:24:16'), ('4bf3a08b53fc66d73ac5460a18c32ee0', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '创建角色', '', '', 'iam:role:platform:opt:create', '', 'create-role', '3', 'auth', '1', '1', '', '0', '0', '2020-03-27 13:55:14', '2020-03-27 13:55:14'), ('4d21ff12678c79adc506d0dfb374ef9f', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '删除', '', '', 'alarm:school:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-02-26 11:56:03', '2020-02-26 11:58:41'), ('4de4af6b04fdd5ae5c5ae3bddf9c966b', 'admin', '4a7c57864b2b25e68989979ef5240566', '4a7c57864b2b25e68989979ef5240566', '系统配置', '', 'layui-icon-util', '', '', '', '1', 'menu', '10000', '1', '', '0', '0', '2020-02-20 17:37:17', '2020-02-21 14:54:54'), ('5608a6f820b7f3111f5c2b50e4449376', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', 'd3fb22faf6a00cc4f947be415b5668d2', '在线办公', '', 'layui-icon-survey', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-02-24 16:18:39', '2020-02-24 16:18:39'), ('5ac84372764b7d019d4676cb92b2fbe6', 'admin', '5b6464b1f355116b18a2798cd8243157', '697958609d3aebf918663485cb4d1b7b', '创建', '', '', 'iam:account:app:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-25 09:21:32', '2020-02-25 09:21:32'), ('5cb2faaf199952e5d34d71d7ee3a45b2', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '编辑', '', '', 'iam:app:opt:update', '', 'update', '1', 'auth', '8', '1', '', '0', '0', '2020-02-21 10:16:23', '2020-02-21 14:10:44'), ('5cc1d8657c193bc07c7f1884a5d1cf2b', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '表格', '', '', 'iam:department/index:data:list', '', 'table', '3', 'auth', '9', '1', '', '1', '0', '2020-03-30 11:57:58', '2020-03-30 11:59:57'), ('5e93210da42bb819d7d6a6c6e4f03f27', 'admin', '4a7c57864b2b25e68989979ef5240566', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '权限菜单', '/iam/permission/index', '', '', '', '', '1', 'menu', '10098', '1', '', '0', '0', '2020-02-21 10:08:58', '2020-02-21 10:08:58'), ('60f0795af032f6800857416e756ec616', 'admin', '4a7c57864b2b25e68989979ef5240566', '2ceb5a25c2f88a846a5f8208f7a63b49', '删除', '', '', 'iam:module:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-02-21 14:12:04', '2020-02-21 14:12:04'), ('64065c89e58a4be6a7fa8f561f6fc270', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '表格', '', '', 'iam:app:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-21 10:14:15', '2020-02-21 14:11:00'), ('644b31d5f09a9094828deb332bb17403', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '项目管理', '/oa/project/index', '', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-02-24 16:18:55', '2020-02-24 16:18:55'), ('697958609d3aebf918663485cb4d1b7b', 'admin', '5b6464b1f355116b18a2798cd8243157', 'e677c2af07e2e2102cf8fb0320a7a9bd', '登录账户管理', '/iam/user/platform', '', '', '', '', '1', 'menu', '97', '1', '', '0', '0', '2020-02-24 17:43:17', '2020-02-25 10:28:40'), ('6d1fdcb4e5a280047b928e39a20d48ce', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '创建', '', '', 'alarm:school:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:55:32', '2020-03-02 18:10:56'), ('6f31ab16a1d65d8f79edd3a773d4b78f', 'admin', '79fbe2152b44a45f523db80f7b1511a1', '7e89596dec40c84d0bf865debfb70d0d', '设备预警', '/device/warning', '', '', '', '', '1', 'menu', '8', '1', '', '0', '0', '2020-02-24 16:17:47', '2020-02-24 16:17:47'), ('71370173a20f5ae12611d5f1063480a3', 'admin', 'e2adc597bd000a235c30389279b2b2c1', 'becc642f531d740aed23bcb58060e43a', '警情日志', '/alarm/logs/event', '', '', '', '', '1', 'menu', '100', '1', '', '0', '0', '2020-02-26 11:53:06', '2020-03-03 00:28:20'), ('742e28369bf88c8e9958e4b7a9bac633', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '查询用户', '', '', 'iam:department:user:data:query', '', 'query-user', '3', 'auth', '1', '1', '', '0', '0', '2020-03-31 10:59:06', '2020-03-31 10:59:06'), ('7afe02054c20fd96e566e60463377702', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '移出', '', '', 'iam:department:user:remove', '', 'remove-user', '3', 'auth', '1', '1', '', '0', '0', '2020-03-31 11:27:49', '2020-03-31 11:27:49'), ('7ca3d7cc1f21bd6bec540764b5a110b5', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '日报管理', '/oa/report/days', '', '', '', '', '1', 'menu', '97', '1', '', '0', '0', '2020-02-24 16:21:42', '2020-02-24 16:21:42'), ('7e89596dec40c84d0bf865debfb70d0d', 'admin', '79fbe2152b44a45f523db80f7b1511a1', '79fbe2152b44a45f523db80f7b1511a1', '访客机管理', '', 'layui-icon-auz', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-02-24 16:17:05', '2020-02-24 16:17:05'), ('86273c0cd39b57e65596405c10d24f09', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '编辑角色', '', '', 'iam:role:platform:opt:update', '', 'update-role', '3', 'auth', '1', '1', '', '0', '0', '2020-03-27 13:55:46', '2020-03-27 13:55:46'), ('89dbb370d84e8b61d735ad3c6eb565f7', 'admin', '1388aebda127e6d7a37a34c447a33e41', 'dfb405117fb48f39ad23549ab78d04c3', '监控管理', '/alarm/school/video', '', '', '', '', '1', 'menu', '98', '1', '', '0', '0', '2020-02-26 11:51:09', '2020-02-26 11:51:09'), ('8acfbfea87c5b6f086fb36d13c8564c9', 'admin', '1388aebda127e6d7a37a34c447a33e41', '89dbb370d84e8b61d735ad3c6eb565f7', '编辑', '', '', 'alarm:school:video:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-02-26 14:41:50', '2020-02-26 14:43:26'), ('8ad247625f7be483de304faf97b294ef', 'admin', '4a7c57864b2b25e68989979ef5240566', '2ceb5a25c2f88a846a5f8208f7a63b49', '编辑', '', '', 'iam:module:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-02-21 14:11:43', '2020-02-21 14:11:43'), ('8aeb58cb752d5debb40e394bad305b0d', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '创建', '', '', 'iam:department/index:opt:create', '', 'create', '2', 'auth', '9', '1', '', '1', '0', '2020-03-30 11:57:59', '2020-03-30 11:59:59'), ('901bfe9d7deae327d4e777cf2fe75d67', 'admin', '4a7c57864b2b25e68989979ef5240566', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '应用管理', '/iam/application/index', '', '', '', '', '1', 'menu', '10100', '1', '', '0', '0', '2020-02-20 17:37:38', '2020-02-21 10:08:14'), ('968013a6233fb4671f394118118404dc', 'admin', '1388aebda127e6d7a37a34c447a33e41', '0cd1654eec7853c17ee767b6370dc115', '编辑', '', '', 'alarm:police:opt:update', '', 'update', '1', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:57:52', '2020-02-26 11:57:52'), ('96cdf9bd4df0b6360ca003801aa286bb', 'admin', '1388aebda127e6d7a37a34c447a33e41', '0cd1654eec7853c17ee767b6370dc115', '删除', '', '', 'alarm:police:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-02-26 11:58:11', '2020-03-02 18:14:06'), ('9a43c65d233a5bfa6bf008a244e712e0', 'admin', '1388aebda127e6d7a37a34c447a33e41', '0cd1654eec7853c17ee767b6370dc115', '表格', '', '', 'alarm:police:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:57:05', '2020-02-26 11:57:05'), ('9d6ff1ee826823b0ae1d5fb9429b6ca9', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '架构用户', '', '', 'iam:department:user:data:list', '', 'dept-users', '3', 'auth', '1', '1', '', '0', '0', '2020-03-30 15:33:34', '2020-03-30 15:33:34'), ('a01eb3e48b22a0ad314af5f2e281ea01', 'admin', 'e2adc597bd000a235c30389279b2b2c1', 'becc642f531d740aed23bcb58060e43a', '操作日志', '/alarm/logs/opt', '', '', '', '', '1', 'menu', '80', '1', '', '0', '0', '2020-02-26 11:53:54', '2020-02-26 11:53:54'), ('a0d055725d3073b00f14bafc1f972381', 'admin', '8c352f9eabb53e16e45c1088da3c4bbd', 'e0e510323334d936dcd128c433874c61', '修改', '', '', '111', '', '111', '2', 'auth', '100', '1', '', '0', '0', '2020-03-02 17:02:29', '2020-03-02 17:02:29'), ('a0e2e236be3e578e9a53f1924f73828e', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '删除', '', '', 'iam:role:opt:delete', '', 'delete', '1', 'auth', '6', '1', '', '0', '0', '2020-02-25 11:33:58', '2020-02-25 11:33:58'), ('a3e8e8bcd783f2ac1f21c70b8ecdcce6', 'admin', '4a7c57864b2b25e68989979ef5240566', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '全局账号', '/iam/user/index', '', '', '', '', '1', 'menu', '10096', '1', '', '0', '0', '2020-02-24 00:37:09', '2020-03-28 09:19:58'), ('a6a782e8aafd75b3e4404598f47ba328', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '删除', '', '', 'iam:app:opt:delete', '', 'delete', '1', 'auth', '7', '1', '', '0', '0', '2020-02-21 10:16:47', '2020-02-21 14:10:40'), ('a84de91ebbcf516e846ada28fb652d61', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '表格', '', '', 'alarm:school:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-26 11:55:13', '2020-02-26 11:58:21'), ('a988bf4d65a375544ae440bc17c40977', 'admin', '4a7c57864b2b25e68989979ef5240566', '5e93210da42bb819d7d6a6c6e4f03f27', '编辑', '', '', 'iam:permission:opt:update', '', 'update', '1', 'auth', '8', '1', '', '0', '0', '2020-02-21 14:13:57', '2020-02-21 14:13:57'), ('ab3badf570a72998ce4115ecace294bf', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '监控', '', '', 'alarm:school:video:data:list', '', 'video', '1', 'auth', '10', '1', '', '0', '0', '2020-02-26 14:48:59', '2020-02-26 14:48:59'), ('ad689e71f4d8198e44660ef63e0f6d10', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '权限', '', '', 'iam:role:permission:opt:permission', '', 'permission', '1', 'auth', '9', '1', '', '0', '0', '2020-02-25 11:34:26', '2020-03-06 11:20:50'), ('aeb31208eb351c4bf916ffae38157abf', 'admin', '5b6464b1f355116b18a2798cd8243157', 'e677c2af07e2e2102cf8fb0320a7a9bd', '组织架构', '/iam/department/index', '', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-03-30 10:54:07', '2020-03-30 11:50:25'), ('b106ec1165a6d16a15b9db7132bd2b6d', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '删除监控', '', '', 'alarm:school:video:opt:delete', '', 'delete_video', '3', 'auth', '5', '1', '', '0', '0', '2020-02-26 14:47:24', '2020-02-26 14:47:24'), ('b59886149928772b8a0e7d1760d30c1c', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '表格', '', '', 'iam:department:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-03-30 12:00:29', '2020-03-30 12:00:29'), ('b700e482885ccb238c963457f0bba4ca', 'admin', '5b6464b1f355116b18a2798cd8243157', 'e677c2af07e2e2102cf8fb0320a7a9bd', '角色管理', '/iam/role/index', '', '', '', '', '1', 'menu', '98', '1', '', '0', '0', '2020-02-24 17:42:23', '2020-02-24 17:44:33'), ('b77eb188e9c19dfd6722a5bb594e0836', 'admin', '8c352f9eabb53e16e45c1088da3c4bbd', 'e0e510323334d936dcd128c433874c61', '删除', '', '', '212', '', '121', '2', 'auth', '1', '1', '', '0', '0', '2020-03-02 18:05:02', '2020-03-02 18:05:02'), ('bba61bc06465d8314b86d254ef630473', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '编辑', '', '', 'iam:department/index:opt:update', '', 'update', '1', 'auth', '9', '1', '', '1', '0', '2020-03-30 11:57:59', '2020-03-30 12:00:01'), ('bbbd1b18fcb4bcb5a484587a4a763e75', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '修改监控', '', '', 'alarm:school:video:opt:update', '', 'update_video', '3', 'auth', '6', '1', '', '0', '0', '2020-02-26 14:47:03', '2020-02-26 14:47:03'), ('becc642f531d740aed23bcb58060e43a', 'admin', 'e2adc597bd000a235c30389279b2b2c1', 'e2adc597bd000a235c30389279b2b2c1', '校视通日志', '', 'layui-icon-engine', '', '', '', '1', 'menu', '90', '1', '仅适用于校视通', '0', '0', '2020-02-24 16:24:27', '2020-02-26 11:59:38'), ('bece329c3ac8a60e2c6ca0b5ca20823d', 'admin', '1388aebda127e6d7a37a34c447a33e41', '89dbb370d84e8b61d735ad3c6eb565f7', '表格', '', '', 'alarm:school:video:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-26 14:41:06', '2020-02-26 14:43:03'), ('bf478daae2ff1219045fe9877fc3794f', 'admin', '5b6464b1f355116b18a2798cd8243157', '5b6464b1f355116b18a2798cd8243157', '组织架构', '', 'layui-icon-component', '', '', '', '1', 'menu', '888', '1', '', '1', '0', '2020-03-30 10:51:40', '2020-03-30 10:52:14'), ('bfbf3de126f8daf113b2c8d07eb68fc6', 'admin', '4a7c57864b2b25e68989979ef5240566', 'a3e8e8bcd783f2ac1f21c70b8ecdcce6', '表格', '', '', 'iam:user:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-24 00:41:29', '2020-02-24 00:41:29'), ('c19a7558360f305f869728d9be328f2b', 'admin', '8c352f9eabb53e16e45c1088da3c4bbd', 'e0e510323334d936dcd128c433874c61', '新增', '', '', '11', '', '111', '2', 'auth', '100', '1', '', '0', '0', '2020-03-02 16:25:52', '2020-03-02 16:25:52'), ('ce6f72ccb33c94e58349755bd67fdb7d', 'admin', '4a7c57864b2b25e68989979ef5240566', '5e93210da42bb819d7d6a6c6e4f03f27', '创建', '', '', 'iam:permission:opt:create', '', 'create', '1', 'auth', '9', '1', '', '0', '0', '2020-02-21 14:13:39', '2020-02-21 14:13:39'), ('cf65fdee8a587495dec813d44c027ddf', 'admin', '1388aebda127e6d7a37a34c447a33e41', '89dbb370d84e8b61d735ad3c6eb565f7', '删除', '', '', 'alarm:school:video:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '0', '0', '2020-02-26 14:42:06', '2020-02-26 14:43:34'), ('cfb979193a2a81a7ec5b34a0dc62b4e4', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '超管', '', '', 'iam:user:application:opt:create', '', 'administrator', '1', 'auth', '11', '1', '', '0', '0', '2020-02-23 18:17:17', '2020-03-27 11:58:10'), ('d6e09dfcc0a8c09d1adb30690ea4c75c', 'admin', '1388aebda127e6d7a37a34c447a33e41', '26126979d34d0e96f5beffa036e1daca', '创建监控', '', '', 'alarm:school:video:opt:create', '', 'create_video', '3', 'auth', '7', '1', '', '0', '0', '2020-02-26 14:46:40', '2020-02-26 14:46:40'), ('dae35adf859aa9d8edce2be5c2a2a4c2', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '工作日报', '/oa/report/day', '', '', '', '', '1', 'menu', '97', '1', '', '0', '0', '2020-02-24 16:20:43', '2020-02-24 16:20:43'), ('ddcfd36503d32a5f6a4fba74085bc11d', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '工作月报', '/oa/report/month', '', '', '', '', '1', 'menu', '95', '1', '', '0', '0', '2020-02-24 16:21:21', '2020-02-24 16:21:21'), ('dfb405117fb48f39ad23549ab78d04c3', 'admin', '1388aebda127e6d7a37a34c447a33e41', '1388aebda127e6d7a37a34c447a33e41', '基础管理', '', 'layui-icon-cols', '', '', '', '1', 'menu', '99', '1', '', '0', '0', '2020-02-26 11:50:00', '2020-02-26 11:50:00'), ('e0b79d2aef0d1602a82b6c42b381c754', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '设置权限', '', '', 'iam:role:permission:opt:permission', '', 'set-perminssion', '3', 'auth', '1', '1', '', '0', '0', '2020-03-27 13:57:45', '2020-03-27 13:57:45'), ('e0e510323334d936dcd128c433874c61', 'admin', '8c352f9eabb53e16e45c1088da3c4bbd', '0b0f0b2437533e3c85c8b7a8437d1570', '菜单', 'www.baidu.com', '', '', '', '', '1', 'menu', '100', '1', '', '0', '0', '2020-03-02 16:25:17', '2020-03-02 16:25:17'), ('e27a5b81067b6a236ab1ca4005ed488f', 'admin', '5b6464b1f355116b18a2798cd8243157', 'aeb31208eb351c4bf916ffae38157abf', '删除', '', '', 'iam:department/index:opt:delete', '', 'delete', '1', 'auth', '8', '1', '', '1', '0', '2020-03-30 11:58:00', '2020-03-30 12:00:03'), ('e358c148cc2a80b6bb09d26182337b45', 'admin', '4a7c57864b2b25e68989979ef5240566', '5e93210da42bb819d7d6a6c6e4f03f27', '表格', '', '', 'iam:permission:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-21 14:13:07', '2020-02-21 14:13:07'), ('e537fbc41e03f053971a038990a13d6a', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '读取管理员', '', '', 'iam:user:application:data:list', '', 'admin_table', '3', 'auth', '7', '1', '', '0', '0', '2020-02-25 00:20:09', '2020-02-25 00:20:09'), ('e5c58fc1323aad12be483124bc9963ab', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '查询用户', '', '', 'iam:user:data:list', '', 'find', '3', 'auth', '8', '1', '', '0', '0', '2020-02-23 18:15:14', '2020-02-23 18:15:14'), ('e677c2af07e2e2102cf8fb0320a7a9bd', 'admin', '5b6464b1f355116b18a2798cd8243157', '5b6464b1f355116b18a2798cd8243157', '应用配置管理', '', 'layui-icon-app', '', '', '', '1', 'menu', '9000', '1', '', '0', '0', '2020-02-24 17:40:53', '2020-02-26 14:50:25'), ('e686f314dc4106bf4748a3aba45cf02a', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '编辑', '', '', 'iam:role:opt:update', '', 'update', '1', 'auth', '8', '1', '', '0', '0', '2020-02-25 11:33:41', '2020-02-25 11:33:41'), ('e6ef4ed2046df07949358daadfaf3f71', 'admin', '5b6464b1f355116b18a2798cd8243157', 'e677c2af07e2e2102cf8fb0320a7a9bd', '组织架构', '/basic/depts/index', 'layui-icon-component', '', '', '', '1', 'menu', '99', '1', '', '1', '0', '2020-02-24 17:44:19', '2020-03-30 10:53:13'), ('e9597ceb48f7b56d3555aa3fcad88641', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '创建', '', '', 'iam:app:opt:create', '', 'create', '2', 'auth', '9', '1', '', '0', '0', '2020-02-21 10:14:52', '2020-02-21 14:10:55'), ('ec27bc22a9ea475cd0a5da4d46607716', 'admin', 'e2adc597bd000a235c30389279b2b2c1', 'becc642f531d740aed23bcb58060e43a', '报警日志', '/alarm/logs/index', '', '', '', '', '1', 'menu', '90', '1', '', '0', '0', '2020-02-24 16:24:58', '2020-02-26 11:54:06'), ('f04ed89cbb47b0ed2d51207ae36f612f', 'admin', '5b6464b1f355116b18a2798cd8243157', 'b700e482885ccb238c963457f0bba4ca', '设置角色', '', '', 'iam:app:role:opt:set', '', 'role', '3', 'auth', '2', '1', '', '0', '0', '2020-02-26 00:09:40', '2020-02-26 00:09:40'), ('f05436bbe73a07dc513684cfa30d6134', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '应用权限', '', '', 'iam:role:permission:data:list', '', 'app-role-perminssion', '3', 'auth', '1', '1', '', '0', '0', '2020-03-27 13:57:03', '2020-03-27 13:57:03'), ('f128551ba567c7d4919ff30e337ea606', 'admin', 'e2adc597bd000a235c30389279b2b2c1', '71370173a20f5ae12611d5f1063480a3', '表格', '', '', 'alarm:event:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-27 08:53:25', '2020-02-27 08:53:25'), ('f2af12b282b2ccf607233d310a6a655b', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '工作周报', '/oa/report/week', '', '', '', '', '1', 'menu', '96', '1', '', '0', '0', '2020-02-24 16:21:00', '2020-02-24 16:21:27'), ('f920f519af0dae90e5c8cc38ec11cb8e', 'admin', '4a7c57864b2b25e68989979ef5240566', '901bfe9d7deae327d4e777cf2fe75d67', '删除角色', '', '', 'iam:role:platform:opt:delete', '', 'delete-role', '3', 'auth', '1', '1', '', '0', '0', '2020-03-27 13:56:04', '2020-03-27 13:56:04'), ('fb4464bb5503f94005a0ff7fec6631aa', 'admin', '5b6464b1f355116b18a2798cd8243157', '697958609d3aebf918663485cb4d1b7b', '表格', '', '', 'iam:user:platform:account:data:list', '', 'table', '3', 'auth', '9', '1', '', '0', '0', '2020-02-25 00:13:06', '2020-03-06 11:06:40'), ('fe1de3fe9686091a5850501ba83fa0b7', 'admin', 'd3fb22faf6a00cc4f947be415b5668d2', '5608a6f820b7f3111f5c2b50e4449376', '任务安排', '/oa/task/task', '', '', '', '', '1', 'menu', '98', '1', '', '0', '0', '2020-02-24 16:19:17', '2020-02-24 16:19:17');
COMMIT;

-- ----------------------------
--  Table structure for `iam_role`
-- ----------------------------
DROP TABLE IF EXISTS `iam_role`;
CREATE TABLE `iam_role` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `name` varchar(50) DEFAULT '' COMMENT '角色名称',
  `grade` smallint(1) DEFAULT '1' COMMENT '角色等级 1-5数字越小优先级越大',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 2冻结 1启用 0禁用',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDefault` smallint(1) DEFAULT '0' COMMENT '默认角色 1是 0否',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `grade` (`grade`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户角色';

-- ----------------------------
--  Records of `iam_role`
-- ----------------------------
BEGIN;
INSERT INTO `iam_role` VALUES ('3508aead54c42d26a97bf4cb46fdb1a9', '5b49a8581c9ca148aec74fd49cba1e02', '11111', '3', '1', '', '0', '0', '0', '2020-03-27 15:58:16', '2020-03-27 15:58:16'), ('3ed3ad8b61dd5fb77aec93d0d85ccfb5', '5b49a8581c9ca148aec74fd49cba1e02', '999', '3', '1', '', '0', '0', '0', '2020-03-27 15:58:09', '2020-03-27 15:58:09'), ('f8773181b96df893d354c0a132d1744f', '5b49a8581c9ca148aec74fd49cba1e02', '12323', '3', '1', '', '1', '0', '0', '2020-03-21 09:32:25', '2020-03-27 11:56:51');
COMMIT;

-- ----------------------------
--  Table structure for `iam_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `iam_role_permission`;
CREATE TABLE `iam_role_permission` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `roleId` varchar(32) NOT NULL COMMENT '角色id 对应iam_role.id',
  `permissionId` varchar(32) NOT NULL COMMENT '权限Id 对应iam_permission.id',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `roleId` (`roleId`),
  KEY `permissionId` (`permissionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色与权限中间表';

-- ----------------------------
--  Records of `iam_role_permission`
-- ----------------------------
BEGIN;
INSERT INTO `iam_role_permission` VALUES ('034b58152b2b906cbc7fb22c7de18777', '0ba500bb4f7af789b0afff96c8b19b44', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('04d56b55e8cdd90815ce1473b171177b', '0ba500bb4f7af789b0afff96c8b19b44', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('04eefd4c1337115d3a51babc4baede30', '5032000d9bd6367bcf17a0e37319c0f1', 'ec27bc22a9ea475cd0a5da4d46607716', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('05144f516b323428bb4ad2a1768c2cb0', '43619f4fcee204e8dd41de6d6ed8ca5a', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('05772fd38f68acbf50df8bb65ce5b25d', '0ba500bb4f7af789b0afff96c8b19b44', '25ef5199dae89bc5191a124c1f128ce5', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('064606969f0a1000ff0e511c460c1d64', '8f357e04b9d9829c4e1021b67ec259e7', 'a3e8e8bcd783f2ac1f21c70b8ecdcce6', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('064d62013634634bb7d2ff3cebcf771f', 'e9aec8b1f0bff15f795fb9965c592e2e', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('080e0026ca876abc0efdc6519549dbaf', '5032000d9bd6367bcf17a0e37319c0f1', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('09179c360dd785194e0f99744fb548a1', 'b4156ef30ffc32ca81d31fc468b63c8a', 'a01eb3e48b22a0ad314af5f2e281ea01', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('09eac885e8ad8fe97a779bca8a806741', 'b4156ef30ffc32ca81d31fc468b63c8a', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('0b7ec82cdbc98bbfa2f42d9b475f6ea3', '43619f4fcee204e8dd41de6d6ed8ca5a', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('0bafd449545ca6210e6b316acaef8dd9', '8f357e04b9d9829c4e1021b67ec259e7', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('0e533e4d66394ccdeb145a42223ee609', 'b4156ef30ffc32ca81d31fc468b63c8a', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('0ef92e6dc17874c9d38fd1b3e3d43222', '8f357e04b9d9829c4e1021b67ec259e7', 'e5c58fc1323aad12be483124bc9963ab', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('0f2ae2700b60078dd2e39f7c64e0f890', '82df04f10fe1aa40dd6591b750ed931f', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('0f94822abec5881092347a394d177c0e', '8f357e04b9d9829c4e1021b67ec259e7', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('0fa8af02750c40f743ab4821cf47ed15', 'cb2c176f1a85249207609604bd2c7878', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('10dc84c3d4839e64b86d05ee03eb3e5b', 'b4156ef30ffc32ca81d31fc468b63c8a', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('13df6fbc89a7b7a50bc1488f661ee4c2', 'b4156ef30ffc32ca81d31fc468b63c8a', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('16aa1da5710479fcf7f125ad5762e06d', '0ba500bb4f7af789b0afff96c8b19b44', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('1749eb96e90370e73d7697fb7d232fb8', '5032000d9bd6367bcf17a0e37319c0f1', 'cf65fdee8a587495dec813d44c027ddf', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('1762a2dcc53238c60bc60fcb89c709de', '5032000d9bd6367bcf17a0e37319c0f1', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('17b39d9c0258137ee3310fd0fa8d70bf', 'cb2c176f1a85249207609604bd2c7878', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('194a57cf326ee44f515c6469f51df938', 'cb2c176f1a85249207609604bd2c7878', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('1f96b56f254bf01aa715a53c2ec37920', '0ba500bb4f7af789b0afff96c8b19b44', '71370173a20f5ae12611d5f1063480a3', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('21283f396c59f78f82a38888195c605e', '0ba500bb4f7af789b0afff96c8b19b44', 'ec27bc22a9ea475cd0a5da4d46607716', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('22d3de88d5f3e835a6f8cae50bf44871', '0ea804171243cfd5e75225af46e48675', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('23f98febb783752f74c51c77e84c3688', '0ba500bb4f7af789b0afff96c8b19b44', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('247a9ce30d10b2bde66322430570c627', '43619f4fcee204e8dd41de6d6ed8ca5a', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('25481a2c247349c105b0c1f33d989749', '0ba500bb4f7af789b0afff96c8b19b44', '6d1fdcb4e5a280047b928e39a20d48ce', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('267c5cfc832321800e449cc07de0319d', '8f357e04b9d9829c4e1021b67ec259e7', '4018f9e5db9c332d81328689a40e0ceb', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('27eaa85b1872f96355bab74ce7f20ed2', '43619f4fcee204e8dd41de6d6ed8ca5a', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('2806d2c115ab380f58e384b8b5c57e25', '5032000d9bd6367bcf17a0e37319c0f1', 'becc642f531d740aed23bcb58060e43a', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('284eacaa3f783743497d6106be864a61', '0ea804171243cfd5e75225af46e48675', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('286313fe31bc96e4d57536be57e05999', 'cb2c176f1a85249207609604bd2c7878', '8acfbfea87c5b6f086fb36d13c8564c9', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('28a620b1012ca7b055c204bb3fe840d4', '8f357e04b9d9829c4e1021b67ec259e7', '2ceb5a25c2f88a846a5f8208f7a63b49', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('28bedd01160d2550c32aeed8c1a1f1dc', '82df04f10fe1aa40dd6591b750ed931f', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('2928c414627f6af218200056746af037', '0ea804171243cfd5e75225af46e48675', '968013a6233fb4671f394118118404dc', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('2a244a87a60f27775d9ef5d9baa4c0dc', '0ba500bb4f7af789b0afff96c8b19b44', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('2ae9083022bb8210d055303c1b49067e', '5032000d9bd6367bcf17a0e37319c0f1', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('2e5eb18a5224892c22777aaa33abd91a', '5032000d9bd6367bcf17a0e37319c0f1', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('305ef9c275c372f54d7dc6b39980dd61', '0ba500bb4f7af789b0afff96c8b19b44', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('31fb73697a6d0d98e7cb80d233c28db1', '8f357e04b9d9829c4e1021b67ec259e7', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('324db7612ff3a8df34a26655003fb527', '0fb03755bc560a9b59f5047753e94b22', '60f0795af032f6800857416e756ec616', '0', '0', '2020-03-27 15:18:49', '2020-03-27 15:18:49'), ('349e211d94c9dc145d17f667acdb61b4', '5032000d9bd6367bcf17a0e37319c0f1', '449ef06381142afb6332ad9c94cf5113', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('38157a3d798e3bab9245dae74b0e6dca', '5032000d9bd6367bcf17a0e37319c0f1', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('3a075c4b98a850c0bdc9d874d8f22eb2', '8f357e04b9d9829c4e1021b67ec259e7', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('3a4b77c63d4e260d1de2db648782cae4', '0ea804171243cfd5e75225af46e48675', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('3de83dbb133a895c814665d06781b062', '8f357e04b9d9829c4e1021b67ec259e7', '8ad247625f7be483de304faf97b294ef', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('3e8d59f4dbdabc7257e0bc4bf61f1e8e', '0ba500bb4f7af789b0afff96c8b19b44', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('3fc2bcf75bdc24d38259a7aa0d54dab5', '8f357e04b9d9829c4e1021b67ec259e7', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('40db054f0921befa735bf6e13de4b866', '8f357e04b9d9829c4e1021b67ec259e7', '7e89596dec40c84d0bf865debfb70d0d', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('4152fbf6da124c1995da48eb5726e989', '8f357e04b9d9829c4e1021b67ec259e7', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('43f2ab1337dd0624fbd8513c20bdaee7', '8f357e04b9d9829c4e1021b67ec259e7', '19e4a1770fbcc10f281f933f14f6bd49', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('446f0709c3e139afdcd7532fbf6d7917', '0ea804171243cfd5e75225af46e48675', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('4753a9634760e7bc7ff9994cc769e0b0', '8f357e04b9d9829c4e1021b67ec259e7', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('48f96d2aa538c05e50143275d5cc45f2', '82df04f10fe1aa40dd6591b750ed931f', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('4943f53e9021f738000dae5aa5c5a157', 'fd53c5a349e46b93ae90710bb8be1a79', '4018f9e5db9c332d81328689a40e0ceb', '0', '0', '2020-02-26 10:47:13', '2020-02-26 10:47:13'), ('494a061ec209af08814da332c29cf214', '82df04f10fe1aa40dd6591b750ed931f', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('4c36b156db6648f0c218f2a39ee1e471', '0ea804171243cfd5e75225af46e48675', '449ef06381142afb6332ad9c94cf5113', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('4d414bb96994b723b7de056d6bb32f18', '0fb03755bc560a9b59f5047753e94b22', '4018f9e5db9c332d81328689a40e0ceb', '0', '0', '2020-03-27 15:18:48', '2020-03-27 15:18:48'), ('4f04928292155737f6118f5ee7650a62', '0ba500bb4f7af789b0afff96c8b19b44', 'becc642f531d740aed23bcb58060e43a', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('4f522c28edd9a8ce1beb1a42b41f05cb', '5032000d9bd6367bcf17a0e37319c0f1', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('4f66ac704c8dda4ec36066a3e8ca815c', 'e9aec8b1f0bff15f795fb9965c592e2e', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('51df6a9e8cdf0f63d0d7fde7f58ab1e6', '5032000d9bd6367bcf17a0e37319c0f1', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('525c1dbe7d9f39cbadd0e37a93169c06', '5032000d9bd6367bcf17a0e37319c0f1', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('5312fe416d85299526860fef62b259ba', '0ea804171243cfd5e75225af46e48675', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('53ad78d3ea4a8300a80aae6773782d8e', '0ea804171243cfd5e75225af46e48675', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('5739d07bb8312001eebdc2c6933db330', 'cb2c176f1a85249207609604bd2c7878', '25ef5199dae89bc5191a124c1f128ce5', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('592168110fed68dac2e9cac2d1420667', '8f357e04b9d9829c4e1021b67ec259e7', '26577e5df76827a465280cec7f865031', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('59294feaf97773ddfb7703e3bec1dda6', 'b4156ef30ffc32ca81d31fc468b63c8a', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('59f27abc200cab6def464cc454fbca1e', '5032000d9bd6367bcf17a0e37319c0f1', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('5b79213a29289b98b7fe703514f38916', '0fb03755bc560a9b59f5047753e94b22', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-03-27 15:18:48', '2020-03-27 15:18:48'), ('5ba7a1f3da4d5924d27296278eb4935b', '5032000d9bd6367bcf17a0e37319c0f1', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('5c50a92a123b791e7344233db700df96', 'b4156ef30ffc32ca81d31fc468b63c8a', '25785a67e4b1acf052abad917979617a', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('5cca7c3337b727a1576cbafbc7fc94c3', '0ba500bb4f7af789b0afff96c8b19b44', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('5d0058837a8382f4f83d8b93ec19293c', '8f357e04b9d9829c4e1021b67ec259e7', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('5e9e6b1a35b4a942bb20f5b900535181', '8f357e04b9d9829c4e1021b67ec259e7', 'bfbf3de126f8daf113b2c8d07eb68fc6', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('602bdafc1d353d35b4a2ec3c96736eda', '0ba500bb4f7af789b0afff96c8b19b44', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('609aa7c3644df48ca394167691bb57e4', '82df04f10fe1aa40dd6591b750ed931f', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('60afe01a44a36734b3a91cd2abcd793a', 'cb2c176f1a85249207609604bd2c7878', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('61fe7cda0b40183d8414ba390af95949', 'b4156ef30ffc32ca81d31fc468b63c8a', '25ef5199dae89bc5191a124c1f128ce5', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('623fa33d9b2c9d7f420aa6729aac3dc9', '8f357e04b9d9829c4e1021b67ec259e7', '79fbe2152b44a45f523db80f7b1511a1', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('6335d54ea2b1ddaa1a45960ab80f822f', '43619f4fcee204e8dd41de6d6ed8ca5a', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('63f7623ec72a95379581982ff09ba688', '5032000d9bd6367bcf17a0e37319c0f1', '89dbb370d84e8b61d735ad3c6eb565f7', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('65af9305ec305f8114549b02df0e9aee', 'e9aec8b1f0bff15f795fb9965c592e2e', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('672631039732a7e4487f81e09ed5bb31', '0ba500bb4f7af789b0afff96c8b19b44', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('6730f40ec8b324798686cf63807b6810', '0fb03755bc560a9b59f5047753e94b22', '2ceb5a25c2f88a846a5f8208f7a63b49', '0', '0', '2020-03-27 15:18:48', '2020-03-27 15:18:48'), ('683897fe7a9a15d4bb22934c188be672', '22c130a2dce077a0a36ccc9979ccda70', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-21 09:32:11', '2020-03-21 09:32:11'), ('683ee9640266710273cab8c78e144e75', '0ba500bb4f7af789b0afff96c8b19b44', 'cf65fdee8a587495dec813d44c027ddf', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('690b2a9e6efaecaf0b9d0f6b1358c330', '0fb03755bc560a9b59f5047753e94b22', '22d799956ff262d2bc45af6e6e059175', '0', '0', '2020-03-27 15:18:49', '2020-03-27 15:18:49'), ('69b85b0ca6d459316d4dcc3648bbbff2', '8f357e04b9d9829c4e1021b67ec259e7', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('6a1884f26e85af711820be9b5a8ffce8', '0ba500bb4f7af789b0afff96c8b19b44', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('6a23cad03c45ca7e180aad04f35695c9', '43619f4fcee204e8dd41de6d6ed8ca5a', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('6cebe0d98699e59896fb9bc39df02a70', 'b4156ef30ffc32ca81d31fc468b63c8a', 'cf65fdee8a587495dec813d44c027ddf', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('6d892dad416de0bcdc88bd681f4613fb', '5032000d9bd6367bcf17a0e37319c0f1', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('6e696c023eaa4974d79899fa09150559', '8f357e04b9d9829c4e1021b67ec259e7', '0b343f2a6357687afcb2688e6c4a31fc', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('6fcbd85fb6b6de3776350b6a1e9d0eda', '0ba500bb4f7af789b0afff96c8b19b44', '449ef06381142afb6332ad9c94cf5113', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('70637fc3d9c583c701cd99776fd6a7eb', '82df04f10fe1aa40dd6591b750ed931f', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('70e34ff0ab4f2363985d6e8bd8fc9a5a', 'b4156ef30ffc32ca81d31fc468b63c8a', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('70ff7ec04ca2541179e08e607f023f58', '0ba500bb4f7af789b0afff96c8b19b44', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('71b0e1fbecc8c31a8bc05ef78c1c08cc', '8f357e04b9d9829c4e1021b67ec259e7', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('73b6380b1f9ae51871526c6f609714fb', '8f357e04b9d9829c4e1021b67ec259e7', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('74b4c546b00de4d9f17da5339145358f', '8f357e04b9d9829c4e1021b67ec259e7', '22d799956ff262d2bc45af6e6e059175', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('74c0e19e1cc874dc431a88d8b878fb84', '0ea804171243cfd5e75225af46e48675', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('74d365952951f7ccf3a55544d64b1f07', 'e9aec8b1f0bff15f795fb9965c592e2e', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('759f255ac76164709fce39ac092de143', 'b4156ef30ffc32ca81d31fc468b63c8a', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('75b5757065a0fc66eef7c017d224b50a', 'cb2c176f1a85249207609604bd2c7878', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('762cbf6c97f8225c9e49ca934aa646af', '0ba500bb4f7af789b0afff96c8b19b44', 'bece329c3ac8a60e2c6ca0b5ca20823d', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('766dbe1edcff64f57abf41b7350195db', 'b4156ef30ffc32ca81d31fc468b63c8a', 'ec27bc22a9ea475cd0a5da4d46607716', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('76705eef78e9157e2da579007be01fa7', '0ba500bb4f7af789b0afff96c8b19b44', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('76a458542a114cbed803f75c73fb6303', 'cb2c176f1a85249207609604bd2c7878', '26126979d34d0e96f5beffa036e1daca', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('7830370e1b11744c85e609039fd89fde', '0fb03755bc560a9b59f5047753e94b22', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-03-27 15:18:48', '2020-03-27 15:18:48'), ('7970ff9454e533d85b3fb7993fce8da2', '5032000d9bd6367bcf17a0e37319c0f1', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('79dd1079ef315652cee19da74b304683', 'b4156ef30ffc32ca81d31fc468b63c8a', 'becc642f531d740aed23bcb58060e43a', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('79ea69e374592155489ace5b959dda3f', 'e9aec8b1f0bff15f795fb9965c592e2e', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('7a24b730988c06d8bfa2a478e2b59ee3', '43619f4fcee204e8dd41de6d6ed8ca5a', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('7ab8217f921f3b2d68cff429d2c19492', '8f357e04b9d9829c4e1021b67ec259e7', 'a988bf4d65a375544ae440bc17c40977', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('7c0931118236bac9dad10023986de5c4', '8f357e04b9d9829c4e1021b67ec259e7', '4017245ead01c7d4ee89ddddd09df077', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('7c72271aa5160c2119766e983aedf48d', '5032000d9bd6367bcf17a0e37319c0f1', 'e2adc597bd000a235c30389279b2b2c1', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('7d20b63b9a1c8a5548dff4c962ed82bc', '43619f4fcee204e8dd41de6d6ed8ca5a', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('7e41ab8586a8bc4a42f06160abbcbbc5', '0ea804171243cfd5e75225af46e48675', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('7e80f9267481e4db04f6d212c441d71c', '43619f4fcee204e8dd41de6d6ed8ca5a', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('7eca4a1f805d9a59bcc48fd1de880002', '8f357e04b9d9829c4e1021b67ec259e7', '66824fe3a127acfbf805149d0c917c3d', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('7ef3ee18ca5d0b5115ee49cb8620c7b4', '8f357e04b9d9829c4e1021b67ec259e7', 'ce6f72ccb33c94e58349755bd67fdb7d', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('7f6c0f32debfd8c09a6e307daf9a140c', '0ba500bb4f7af789b0afff96c8b19b44', 'a01eb3e48b22a0ad314af5f2e281ea01', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('80b5896890d4c7c7f761b0d15e37f84a', '0ba500bb4f7af789b0afff96c8b19b44', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('813b736d2d7530caed679189c7a6bc41', 'cb2c176f1a85249207609604bd2c7878', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('81ffaeeb3fbc0a920bc72f1e77eb2dcf', '0ba500bb4f7af789b0afff96c8b19b44', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('845d775e86f6a7516d7cceb44d60ce0a', '5032000d9bd6367bcf17a0e37319c0f1', '6d1fdcb4e5a280047b928e39a20d48ce', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('872805f0617527cf24c366a7e9b67507', '0ba500bb4f7af789b0afff96c8b19b44', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('88a19379e37ff953442bd0d12e51ee56', 'cb2c176f1a85249207609604bd2c7878', '96cdf9bd4df0b6360ca003801aa286bb', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('8935230b825104ff49ba3dd6d56df0ce', '8f357e04b9d9829c4e1021b67ec259e7', 'e358c148cc2a80b6bb09d26182337b45', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('8b873596cfd00fffd66d06db535cc57d', '0ba500bb4f7af789b0afff96c8b19b44', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('8c3cac3b3c1c0fcb507ba175e3c28b00', '43619f4fcee204e8dd41de6d6ed8ca5a', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('8cc97dcc11348212621875bd06c45b93', '82df04f10fe1aa40dd6591b750ed931f', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('8dae8af68f1a78768e7d2ca9216bcc41', '8f357e04b9d9829c4e1021b67ec259e7', '08cb3a3bc1e800e39f12c24004bccf7b', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('8fe029c8d07a3d51bbd36d17df258437', '0ba500bb4f7af789b0afff96c8b19b44', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('8ffb23537c677f88e419c12ae1ae1253', 'e9aec8b1f0bff15f795fb9965c592e2e', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('920a15a8f9ce2231f06395870bf59319', '8f357e04b9d9829c4e1021b67ec259e7', '60f0795af032f6800857416e756ec616', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('937482912bb0effe7a9a84d1f1e0b92d', 'b4156ef30ffc32ca81d31fc468b63c8a', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('9429413146892c13ab3255b68c0e5f29', '0ba500bb4f7af789b0afff96c8b19b44', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('944557c27c10e0823f0193945dd7b231', '8f357e04b9d9829c4e1021b67ec259e7', '5e93210da42bb819d7d6a6c6e4f03f27', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('945d15be75c934eaf2da8b8721fac868', '5032000d9bd6367bcf17a0e37319c0f1', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('95b849ac123e4c6c285e7ed0f72783ce', '8f357e04b9d9829c4e1021b67ec259e7', '0bcfb0abface8cca933d1257c8c94473', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('96d5a25c872b14a5a602bc283828a442', '5032000d9bd6367bcf17a0e37319c0f1', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('98ca27e94c1963601fd960d63a67697a', '0ba500bb4f7af789b0afff96c8b19b44', '8acfbfea87c5b6f086fb36d13c8564c9', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('9938a257a172f648658abc38bd29c056', '8f357e04b9d9829c4e1021b67ec259e7', '901bfe9d7deae327d4e777cf2fe75d67', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('9b48134b96aab9563b9f3eeb7a6f5bf3', 'fd53c5a349e46b93ae90710bb8be1a79', '4a7c57864b2b25e68989979ef5240566', '0', '0', '2020-02-26 10:47:13', '2020-02-26 10:47:13'), ('9c4d1a5f19f7231b387803953b480784', 'b4156ef30ffc32ca81d31fc468b63c8a', '968013a6233fb4671f394118118404dc', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('9d3d6f9a22bd86a7ec09d3f7cf3d4718', 'cb2c176f1a85249207609604bd2c7878', 'cf65fdee8a587495dec813d44c027ddf', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('9d875fa56e1aee9a389b4db242b57378', 'cb2c176f1a85249207609604bd2c7878', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('9df5160cabc8b278b69a1e7f7cd47944', '0ea804171243cfd5e75225af46e48675', 'ec27bc22a9ea475cd0a5da4d46607716', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('9fe3864de497fbb771ff26178ed27841', 'b4156ef30ffc32ca81d31fc468b63c8a', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('a108a911e619ff898746ed582f24c038', '5032000d9bd6367bcf17a0e37319c0f1', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('a1e33e9e1b82fdb3291476e578659391', '0ba500bb4f7af789b0afff96c8b19b44', '968013a6233fb4671f394118118404dc', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('a2918d516bdfbb7d08361c3617350e62', 'b4156ef30ffc32ca81d31fc468b63c8a', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('a2c70fd001b73d15584724e051144fd0', '8f357e04b9d9829c4e1021b67ec259e7', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('a2dbb0167071066e4a14cb3faf66c883', '43619f4fcee204e8dd41de6d6ed8ca5a', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('a50536a4c0d010e0a820a38c6ec576d2', '82df04f10fe1aa40dd6591b750ed931f', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('a53292b24ecbf7a3f75cfb020efeac68', '5032000d9bd6367bcf17a0e37319c0f1', '5ac84372764b7d019d4676cb92b2fbe6', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('a5a962821810f6df3e4ff0d6beea95ff', '0ea804171243cfd5e75225af46e48675', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('a659467c20b44f3edffdd254796482f3', '0ba500bb4f7af789b0afff96c8b19b44', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('a65c76ee3c95d08d97b939c11aa62ce1', '43619f4fcee204e8dd41de6d6ed8ca5a', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('a789b9b9c4aaf50abb4caf54e01928cf', '5032000d9bd6367bcf17a0e37319c0f1', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('a7c4a86735597cc1c0df2bee60753803', '5032000d9bd6367bcf17a0e37319c0f1', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('a8044e3136e58e0995ea1865ca9782f2', '8f357e04b9d9829c4e1021b67ec259e7', '732af14c7ed76bb45720bc0015a0a28b', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('a8090007ff9dcb7e344d66823dccf20d', '82df04f10fe1aa40dd6591b750ed931f', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('a95f499f9747c1277bc738b22d7e132f', '5032000d9bd6367bcf17a0e37319c0f1', '968013a6233fb4671f394118118404dc', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('abae0d26e5ed6443ead97927832f630a', 'e9aec8b1f0bff15f795fb9965c592e2e', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('abd10971aa837bf06b87454bfd937acb', 'cb2c176f1a85249207609604bd2c7878', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('acc0afccfa7cf4ae567c340217c60f4f', '0ea804171243cfd5e75225af46e48675', 'e2adc597bd000a235c30389279b2b2c1', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('acd7cff716ee4fc19e898e73ce3cf7ef', '5032000d9bd6367bcf17a0e37319c0f1', '25785a67e4b1acf052abad917979617a', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('ae27270562ac5f72bf3788646dc2c9b1', '5032000d9bd6367bcf17a0e37319c0f1', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('ae290b4de2fa61c60adae2df493ee5dc', '8f357e04b9d9829c4e1021b67ec259e7', '13ad79fc9659786981ff7ad219a32862', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('aed6e1f255f3644e74021bd5f2751aad', '43619f4fcee204e8dd41de6d6ed8ca5a', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('af89eac741347ccccc9bac3a46c1f13d', '0ba500bb4f7af789b0afff96c8b19b44', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('b095724528ad8a67c9f98c3c0d868962', '0ba500bb4f7af789b0afff96c8b19b44', '697958609d3aebf918663485cb4d1b7b', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('b115a4c71b5aad5bc566822b3edd6e94', '5032000d9bd6367bcf17a0e37319c0f1', '46ee24a950e34bc3c42835e8e0305030', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('b1ad701a6237407c891d4b93917f18c6', '43619f4fcee204e8dd41de6d6ed8ca5a', '30e466f84d0ef85d933a4c22768cd0d6', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('b1f5a53863e94309cfcb4bb4e96b9e15', 'cb2c176f1a85249207609604bd2c7878', '968013a6233fb4671f394118118404dc', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('b26c9d5b66a4446f8c2786168e7c1dce', '0ba500bb4f7af789b0afff96c8b19b44', '0080f69c5b5bf4a87eb8866010ae624d', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('b2bc1d575ca4f1a029edd6b98b60e46c', 'b4156ef30ffc32ca81d31fc468b63c8a', '8acfbfea87c5b6f086fb36d13c8564c9', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('b34ad2924c599c1eafcdc939f1ae7e13', '0ba500bb4f7af789b0afff96c8b19b44', '89dbb370d84e8b61d735ad3c6eb565f7', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('b7dfbbbff3e27f0db2af7dff7f232c7f', '43619f4fcee204e8dd41de6d6ed8ca5a', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('b7f7229696e4876f130af8ed3d229a22', '0ea804171243cfd5e75225af46e48675', 'a01eb3e48b22a0ad314af5f2e281ea01', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('b9a0214e8501beb2ed89f9d09bf50f9b', 'b4156ef30ffc32ca81d31fc468b63c8a', 'bbbd1b18fcb4bcb5a484587a4a763e75', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('bba59dff63d0cc38c9602a1291fc2fc0', '8f357e04b9d9829c4e1021b67ec259e7', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('bbd889ad62f919a2c30a048327f853d7', 'cb2c176f1a85249207609604bd2c7878', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('bc758be2bd86dad5a3de504d6f67e1c4', '8f357e04b9d9829c4e1021b67ec259e7', '6f31ab16a1d65d8f79edd3a773d4b78f', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('bd40861dcc02d6aaf99b50c239fe4097', 'cb2c176f1a85249207609604bd2c7878', '6d1fdcb4e5a280047b928e39a20d48ce', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('bd4d0fffcb60d34a187fc10b9a65c710', '5032000d9bd6367bcf17a0e37319c0f1', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('bd86d0f2e55307fec82fd51ebd91dd0f', '0ea804171243cfd5e75225af46e48675', 'becc642f531d740aed23bcb58060e43a', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('bdc8760c7066a3b4ab6d8db6646296f1', '82df04f10fe1aa40dd6591b750ed931f', 'f04ed89cbb47b0ed2d51207ae36f612f', '0', '0', '2020-03-03 14:02:38', '2020-03-03 14:02:38'), ('be8fdb4829627174ab3f324a5f66622b', '8f357e04b9d9829c4e1021b67ec259e7', 'a6a782e8aafd75b3e4404598f47ba328', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('bf0323b5838748eedf398d0d54c46a63', 'cb2c176f1a85249207609604bd2c7878', '25785a67e4b1acf052abad917979617a', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('c0dfa4aa19d3de8657312c8d9f57c3c2', '5032000d9bd6367bcf17a0e37319c0f1', '0cd1654eec7853c17ee767b6370dc115', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('c2f8342105de03748092ed98c463ab06', 'b4156ef30ffc32ca81d31fc468b63c8a', 'bece329c3ac8a60e2c6ca0b5ca20823d', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('c75e09bf07b3a562cd63b1efd542f786', 'cb2c176f1a85249207609604bd2c7878', '89dbb370d84e8b61d735ad3c6eb565f7', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('c9400f388d1cdd9b389e223f5228c008', '8f357e04b9d9829c4e1021b67ec259e7', '274be732b3904ce997d5830e8c0df3a4', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('cb4e0bc1aaa0ba0588fa08c9efa9adae', '5032000d9bd6367bcf17a0e37319c0f1', 'a01eb3e48b22a0ad314af5f2e281ea01', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('cb53bbeff50ba357f05eb447b94604e4', 'b4156ef30ffc32ca81d31fc468b63c8a', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('cb67d2a246a32e19ca3788fb8d29e501', '8f357e04b9d9829c4e1021b67ec259e7', 'a0e2e236be3e578e9a53f1924f73828e', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('cb7b011405b96aab1d1fd8bd2b5000aa', '0ea804171243cfd5e75225af46e48675', '71370173a20f5ae12611d5f1063480a3', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('cc645cb0c192bd4739852688b2e8ede3', '8f357e04b9d9829c4e1021b67ec259e7', 'cfb979193a2a81a7ec5b34a0dc62b4e4', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('cca94a67992a261f4f684e4485681211', '0fb03755bc560a9b59f5047753e94b22', '8ad247625f7be483de304faf97b294ef', '0', '0', '2020-03-27 15:18:49', '2020-03-27 15:18:49'), ('cccde20db6191071eeddabfab57c54e0', 'b4156ef30ffc32ca81d31fc468b63c8a', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('cf55a5c523f00265e8527eae08954cfe', '22c130a2dce077a0a36ccc9979ccda70', 'e6ef4ed2046df07949358daadfaf3f71', '0', '0', '2020-03-21 09:32:11', '2020-03-21 09:32:11'), ('d0b1aeb3cbd08f9b174c72eeb6c4d1fe', '0ba500bb4f7af789b0afff96c8b19b44', 'e686f314dc4106bf4748a3aba45cf02a', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('d4e3bd732fa13d4f8a9237d2afefd784', 'b4156ef30ffc32ca81d31fc468b63c8a', 'e2adc597bd000a235c30389279b2b2c1', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('d65ebb57d82ec90e1fd0ba17c7fc5921', '5032000d9bd6367bcf17a0e37319c0f1', 'd6e09dfcc0a8c09d1adb30690ea4c75c', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('d9cbd49293913c8982646feece26a61b', '5032000d9bd6367bcf17a0e37319c0f1', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('daa0fa610243ede10aecaea7da9ece63', 'fd53c5a349e46b93ae90710bb8be1a79', '4de4af6b04fdd5ae5c5ae3bddf9c966b', '0', '0', '2020-02-26 10:47:13', '2020-02-26 10:47:13'), ('dcab191f9707fe2a39140861b318790c', '5032000d9bd6367bcf17a0e37319c0f1', '71370173a20f5ae12611d5f1063480a3', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('ddb61626d7803d626c1904be86a3209c', 'e9aec8b1f0bff15f795fb9965c592e2e', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-27 15:19:17', '2020-03-27 15:19:17'), ('ddbc45d975bdcfbf4c5fc4eb1caf8059', 'b4156ef30ffc32ca81d31fc468b63c8a', '449ef06381142afb6332ad9c94cf5113', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('de4341d90b7e68150b54f412c879e07d', 'fd53c5a349e46b93ae90710bb8be1a79', '2ceb5a25c2f88a846a5f8208f7a63b49', '0', '0', '2020-02-26 10:47:13', '2020-02-26 10:47:13'), ('dfb53abfc3be6286e9f604bfa2a95a96', '8f357e04b9d9829c4e1021b67ec259e7', '177a965f68712d79bc9722ad24b4396f', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('dfeb4919018505c957f092ae2d53128f', '43619f4fcee204e8dd41de6d6ed8ca5a', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-06 11:31:37', '2020-03-06 11:31:37'), ('e1314a8bde46ee556ed0bbf2ae1ef112', '0ea804171243cfd5e75225af46e48675', 'b106ec1165a6d16a15b9db7132bd2b6d', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('e27aaa56a76321696a702574e1bb4732', '0ba500bb4f7af789b0afff96c8b19b44', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('e2c25f940c18a45197a0902b9085da1b', '5032000d9bd6367bcf17a0e37319c0f1', '25ef5199dae89bc5191a124c1f128ce5', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('e32b538e56d99a89421d6982f6cbf610', 'b4156ef30ffc32ca81d31fc468b63c8a', '89dbb370d84e8b61d735ad3c6eb565f7', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('e56e6ccc363da2fcc95ccfd0a1ee6f99', '0ba500bb4f7af789b0afff96c8b19b44', 'e677c2af07e2e2102cf8fb0320a7a9bd', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('e6311fdbfcb6514ae72398c54fa87540', '8f357e04b9d9829c4e1021b67ec259e7', '64065c89e58a4be6a7fa8f561f6fc270', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('e6485688684270c20a94a9e5dd297ce9', '8f357e04b9d9829c4e1021b67ec259e7', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('e79cba1844657e0c5c62be95237047eb', '8f357e04b9d9829c4e1021b67ec259e7', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('e861c802fe776a80b3023205c99fee1b', '8f357e04b9d9829c4e1021b67ec259e7', '888483cf88e186ee28b70a8105dd9ceb', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('ea3b338101e166e0be2bd8b874f4be88', '5032000d9bd6367bcf17a0e37319c0f1', '171fe7c7e717d0755d08745975424686', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('ebe3a3d8e59b9661f69f96abf8acfacd', '5032000d9bd6367bcf17a0e37319c0f1', 'a84de91ebbcf516e846ada28fb652d61', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('edd977c134fe5df62aa383e9bfa3848e', 'b4156ef30ffc32ca81d31fc468b63c8a', '71370173a20f5ae12611d5f1063480a3', '0', '0', '2020-03-06 15:58:27', '2020-03-06 15:58:27'), ('efcd287cf4d5826cd4d59983d992be8e', '8f357e04b9d9829c4e1021b67ec259e7', '5cb2faaf199952e5d34d71d7ee3a45b2', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('efda6d5e0b208971e9339a6c01641c15', '5032000d9bd6367bcf17a0e37319c0f1', '8acfbfea87c5b6f086fb36d13c8564c9', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('f07dbf6bd65d535ac23b96e145995701', '0ea804171243cfd5e75225af46e48675', '9a43c65d233a5bfa6bf008a244e712e0', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('f0fd3b8109befaf538479098f784738e', '0ea804171243cfd5e75225af46e48675', '6d1fdcb4e5a280047b928e39a20d48ce', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('f1965ef60b6ebc7661c7e47f86435363', '0ba500bb4f7af789b0afff96c8b19b44', 'fb4464bb5503f94005a0ff7fec6631aa', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('f34ade1f99ba0006b78c3a1ccca8ab55', 'cb2c176f1a85249207609604bd2c7878', '1388aebda127e6d7a37a34c447a33e41', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('f37d8335ca65ae0342530b9cde26bb8c', 'cb2c176f1a85249207609604bd2c7878', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('f4de3621210a04f1c5c312f73f612f70', '0ba500bb4f7af789b0afff96c8b19b44', 'e2adc597bd000a235c30389279b2b2c1', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('f552563151790b28c31360525c94960c', '0ea804171243cfd5e75225af46e48675', '2b93fcf0a6612413d3fbac131bbef7b9', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('f5f023536475b061e346ab43df59bee2', '0ba500bb4f7af789b0afff96c8b19b44', '25785a67e4b1acf052abad917979617a', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('f70b3cff8c631f2c37e925d48f824493', '5032000d9bd6367bcf17a0e37319c0f1', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('f740b0fedafa5a9b3b667510c632f7ae', '0ba500bb4f7af789b0afff96c8b19b44', 'ab3badf570a72998ce4115ecace294bf', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('f76028f66f399a7551e9ca54995ddb65', '8f357e04b9d9829c4e1021b67ec259e7', 'e9597ceb48f7b56d3555aa3fcad88641', '0', '0', '2020-03-03 15:09:53', '2020-03-03 15:09:53'), ('faa8a75093443219558e497a132752f6', '0ba500bb4f7af789b0afff96c8b19b44', 'b700e482885ccb238c963457f0bba4ca', '0', '0', '2020-03-02 15:44:43', '2020-03-02 15:44:43'), ('faf23f94a9a720fc7fc20bfcf9e7bfab', '5032000d9bd6367bcf17a0e37319c0f1', 'bece329c3ac8a60e2c6ca0b5ca20823d', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('fb807f640a4d2b16e4974acd0405295b', '5032000d9bd6367bcf17a0e37319c0f1', '4d21ff12678c79adc506d0dfb374ef9f', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('fcfdef09c940823f5fbd1928e0c3db03', '0ea804171243cfd5e75225af46e48675', 'dfb405117fb48f39ad23549ab78d04c3', '0', '0', '2020-03-12 14:58:27', '2020-03-12 14:58:27'), ('fd0d984a3d907e823354855f3ae6d693', '5032000d9bd6367bcf17a0e37319c0f1', 'ad689e71f4d8198e44660ef63e0f6d10', '0', '0', '2020-02-26 18:10:54', '2020-02-26 18:10:54'), ('fef0c76f9f366049571968427e92e636', 'cb2c176f1a85249207609604bd2c7878', 'bece329c3ac8a60e2c6ca0b5ca20823d', '0', '0', '2020-03-03 11:10:54', '2020-03-03 11:10:54'), ('fffce3df7e9b030e98bcac767bab9fb2', '22c130a2dce077a0a36ccc9979ccda70', '5b6464b1f355116b18a2798cd8243157', '0', '0', '2020-03-21 09:32:11', '2020-03-21 09:32:11');
COMMIT;

-- ----------------------------
--  Table structure for `iam_user`
-- ----------------------------
DROP TABLE IF EXISTS `iam_user`;
CREATE TABLE `iam_user` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `realName` varchar(100) DEFAULT '' COMMENT '真实姓名',
  `mobile` varchar(100) DEFAULT '' COMMENT '手机号码 唯一判断',
  `gender` varchar(2) DEFAULT '' COMMENT '性别 男 女',
  `email` varchar(100) DEFAULT '' COMMENT '电子邮箱',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像',
  `state` smallint(1) DEFAULT '1' COMMENT '状态 2冻结 1启用 0禁用',
  `ext` mediumtext COMMENT '扩展数据',
  `remark` varchar(200) DEFAULT '' COMMENT '备注',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `realName` (`realName`),
  KEY `state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基础用户';

-- ----------------------------
--  Records of `iam_user`
-- ----------------------------
BEGIN;
INSERT INTO `iam_user` VALUES ('123', '999', '13788888888', '', '', '', '1', null, '', '0', '0', '2020-03-21 11:46:27', '2020-03-21 11:46:27'), ('1715e76956b14be6b35f22cf5a2861fe', '123', '123', '保密', '', '', '1', null, '', '0', '0', '2020-03-19 16:12:22', '2020-03-19 16:12:22'), ('441f1d3bc6664e3fb3c4342e4b721d3e', '3333', '15888888881', '保密', '', '', '1', null, '', '0', '0', '2020-03-27 16:02:25', '2020-03-27 16:02:25'), ('53bb809f24f44d93a9127c41b8e25167', '333', '17138294574', '保密', '', '', '1', null, '', '0', '0', '2020-03-27 16:00:37', '2020-03-27 16:00:37'), ('867b6a71cb2b4a22abd8e918eb1a1371', '123', '13700000001', '保密', '', '', '1', null, '', '0', '0', '2020-03-27 15:58:27', '2020-03-27 15:58:27'), ('a2869d22ba004ee3be09843f4695c59b', 'Taller', '18154579950', '保密', 'airshy@163.com', '', '1', null, '', '0', '0', '2020-02-24 10:12:15', '2020-02-24 10:12:15'), ('d761a73e10744d73a766f8d134a7d93f', 'Soda1', '17138294576', '保密', '', '', '1', null, '', '0', '0', '2020-03-27 15:21:40', '2020-03-27 15:21:40');
COMMIT;

-- ----------------------------
--  Table structure for `iam_user_application`
-- ----------------------------
DROP TABLE IF EXISTS `iam_user_application`;
CREATE TABLE `iam_user_application` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `userId` varchar(32) NOT NULL COMMENT '基础用户Id 对应iam_user.id',
  `isAdmin` tinyint(1) DEFAULT '0' COMMENT '是否超管 1是 0否',
  `archives` longtext COMMENT '档案',
  `isLeave` tinyint(1) DEFAULT '0' COMMENT '移除状态 1是 0否',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `userId` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与应用关系中间表';

-- ----------------------------
--  Records of `iam_user_application`
-- ----------------------------
BEGIN;
INSERT INTO `iam_user_application` VALUES ('064499a82a4c32dc46d4126426e25516', '5b49a8581c9ca148aec74fd49cba1e02', '16b6ca79e4014cd7b1fe8ca9fdf68237', '0', null, '0', '0', '0', '2020-03-03 16:11:55', '2020-03-03 16:11:55'), ('06a92d2c410b7eff7436657a29a2e798', '180458fa6deb56075de51d4d7354571b', '1715e76956b14be6b35f22cf5a2861fe', '0', null, '0', '0', '0', '2020-03-20 13:57:41', '2020-03-20 13:57:44'), ('0a849294947f03cec775771a644d4399', '892d41b054334bb5087733f0f5bbcddf', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-03-18 10:09:46', '2020-03-18 10:09:46'), ('13a3f1c96f2f27441551fb8d5a5f3941', 'f2e5f0598978c156186d705a1f27472e', 'b8de0a83f59442d3aaa90dedd938e239', '0', null, '0', '0', '0', '2020-03-03 09:35:18', '2020-03-03 09:35:18'), ('23f3aafb7905b6bf13a07c5cc54767e0', '5b49a8581c9ca148aec74fd49cba1e02', 'c18c80078b5a49e595260ff59ee66e43', '0', null, '0', '0', '0', '2020-03-04 15:44:44', '2020-03-19 13:40:04'), ('35b8e2abf789de784df1ebdf786b9c8a', 'f2e5f0598978c156186d705a1f27472e', '615c5ac6149c441ba32580ee85c00e5c', '0', null, '0', '0', '0', '2020-03-03 09:36:24', '2020-03-03 09:36:24'), ('35dae43c05d983ff430a42ff27fb6bea', 'f2e5f0598978c156186d705a1f27472e', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-02-26 12:00:07', '2020-02-26 12:00:07'), ('3654f7aa90da5396ee891b91ff8751eb', '456c0f7a31a9795c3910e2993368d1b4', '76a6efd1b91043b7ac52b63d0e184d54', '1', null, '0', '0', '0', '2020-03-03 14:16:33', '2020-03-03 14:16:33'), ('3d839186f47b6e012f4d840dd31e6180', 'f2e5f0598978c156186d705a1f27472e', '062a1dbab9844e56ba38841e4207a27c', '0', null, '0', '0', '0', '2020-03-03 15:15:40', '2020-03-03 15:22:19'), ('3dea90853a52ea7f511b458c40dd000d', '456c0f7a31a9795c3910e2993368d1b4', 'efd6f1b582534c27af57c32f38897308', '0', null, '0', '0', '0', '2020-03-03 14:01:30', '2020-03-03 14:01:30'), ('4b8b5bd8f5c0e8cbbbaef785ed475bf2', 'd95d698c118bece1e2acb9810566d3a1', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-03-03 16:15:20', '2020-03-03 16:15:20'), ('4d4d8fc29c32a259ffe54ae63670422c', 'f2e5f0598978c156186d705a1f27472e', '76a6efd1b91043b7ac52b63d0e184d54', '0', null, '0', '0', '0', '2020-03-03 15:25:17', '2020-03-03 15:26:36'), ('5aded79234a2bf13875760c7ed01eef8', '5b49a8581c9ca148aec74fd49cba1e02', '3fc57a47ae6c4a25b7a5aa98ac9c8653', '0', null, '0', '0', '0', '2020-02-26 00:40:01', '2020-02-26 00:40:01'), ('67c71f98766dee6fdc3137d439d66745', 'f2e5f0598978c156186d705a1f27472e', 'e72da61ff5ba4c3baeec6ff235a8302d', '0', null, '0', '0', '0', '2020-03-03 15:59:04', '2020-03-03 15:59:04'), ('68a2842d9cd16a471bfd00a5aff1c5dc', '5b49a8581c9ca148aec74fd49cba1e02', 'b3caf4e80ed04b5a900555016fba03fc', '0', null, '0', '0', '0', '2020-03-03 16:01:34', '2020-03-03 16:01:34'), ('691467a402197cb93c75c564790d9dd2', '0d479f38aa5a002adba1fe9d67d1664a', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-03-03 15:03:39', '2020-03-03 15:03:39'), ('6c0157dc219da0b4ed89b86a9fd7b9cc', 'f2e5f0598978c156186d705a1f27472e', 'f8738c494c9b494cb487333e76a178ce', '0', null, '0', '0', '0', '2020-03-05 15:14:13', '2020-03-05 15:14:13'), ('8515ee32dcb6f74e7cef45227f8ba70a', 'f2e5f0598978c156186d705a1f27472e', 'c18c80078b5a49e595260ff59ee66e43', '1', null, '0', '0', '0', '2020-03-03 15:26:40', '2020-03-03 15:26:40'), ('b18fdd76fd83e3e35fca7a523278189e', '456c0f7a31a9795c3910e2993368d1b4', '0b362cace80a40aeb919c546c2c2d832', '0', null, '0', '0', '0', '2020-03-03 14:03:42', '2020-03-03 14:03:42'), ('b403ef4f657feca2beebabd8dc7c6060', '5b49a8581c9ca148aec74fd49cba1e02', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-03-19 13:40:18', '2020-03-19 13:40:18'), ('b7edbad0d476418bb3a37e41242feb0b', 'a0ee0c06a24656d8157ddead6ce0f83d', '1715e76956b14be6b35f22cf5a2861fe', '0', null, '0', '0', '0', '2020-03-20 13:48:08', '2020-03-20 13:48:11'), ('c4f7a5d3afc09e483b50073b2b4a1ab6', 'f2e5f0598978c156186d705a1f27472e', '21c5ea36b43f4a8b9de7a1080f19c03d', '1', null, '0', '0', '0', '2020-03-09 16:35:25', '2020-03-09 16:35:25'), ('d0cc5b25bb2be55016a94b4ec047518a', 'f2e5f0598978c156186d705a1f27472e', 'c5bba1ea3d6a4759821b51162d80f6ae', '0', null, '0', '0', '0', '2020-02-26 16:00:58', '2020-02-26 16:00:58'), ('da38b445049fa32ac4704a04c2dc59ee', '0d479f38aa5a002adba1fe9d67d1664a', '76a6efd1b91043b7ac52b63d0e184d54', '1', null, '0', '0', '0', '2020-03-03 15:04:43', '2020-03-03 15:04:43'), ('e325e418c86a31b09b5369fefa3a179f', 'bdfc666aacebd46c847b0300043c49db', 'a2869d22ba004ee3be09843f4695c59b', '1', null, '0', '0', '0', '2020-03-18 10:09:55', '2020-03-18 10:09:55'), ('f24fcef994cfbbf267af61ac01a8e562', '5b49a8581c9ca148aec74fd49cba1e02', '21c5ea36b43f4a8b9de7a1080f19c03d', '0', null, '0', '0', '0', '2020-03-09 16:34:21', '2020-03-19 13:40:01');
COMMIT;

-- ----------------------------
--  Table structure for `iam_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `iam_user_role`;
CREATE TABLE `iam_user_role` (
  `id` varchar(32) NOT NULL COMMENT 'ID',
  `appId` varchar(32) NOT NULL COMMENT '所属应用id 对应iam_application.id',
  `userId` varchar(32) NOT NULL COMMENT '基础用户Id 对应iam_user.id',
  `roleId` varchar(32) NOT NULL COMMENT '角色Id 对应iam_role.id',
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `createBy` varchar(32) DEFAULT '0' COMMENT '创建人',
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `appId` (`appId`),
  KEY `userId` (`userId`),
  KEY `roleId` (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与角色关系中间表';

-- ----------------------------
--  Records of `iam_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `iam_user_role` VALUES ('21a387df483775f5ed57031eaf10bf38', '5b49a8581c9ca148aec74fd49cba1e02', '53bb809f24f44d93a9127c41b8e25167', '3ed3ad8b61dd5fb77aec93d0d85ccfb5', '0', '0', '2020-03-27 16:11:10', '2020-03-27 16:11:10'), ('294ec2b758cdbf4555b4ca6ac80f0987', '456c0f7a31a9795c3910e2993368d1b4', 'efd6f1b582534c27af57c32f38897308', '82df04f10fe1aa40dd6591b750ed931f', '0', '0', '2020-03-03 14:03:30', '2020-03-03 14:03:30'), ('37ad686342a045e1eb6cd72510efe87f', 'f2e5f0598978c156186d705a1f27472e', '615c5ac6149c441ba32580ee85c00e5c', '0ea804171243cfd5e75225af46e48675', '0', '0', '2020-03-12 14:58:43', '2020-03-12 14:58:43'), ('4fd2a00d47268cce6fa248c18e5158af', '5b49a8581c9ca148aec74fd49cba1e02', '53bb809f24f44d93a9127c41b8e25167', 'f8773181b96df893d354c0a132d1744f', '0', '0', '2020-03-27 16:11:10', '2020-03-27 16:11:10'), ('5cd6705a6f2851774bf5f0b3b1fb6091', 'f2e5f0598978c156186d705a1f27472e', 'b8de0a83f59442d3aaa90dedd938e239', 'b4156ef30ffc32ca81d31fc468b63c8a', '0', '0', '2020-03-06 16:21:52', '2020-03-06 16:21:52'), ('7205b8adbb819d1dcbe069c383134279', '5b49a8581c9ca148aec74fd49cba1e02', 'a2869d22ba004ee3be09843f4695c59b', 'fd53c5a349e46b93ae90710bb8be1a79', '0', '0', '2020-02-26 00:20:26', '2020-02-26 00:20:26'), ('74380ba29915f7fc5d36a1f990b42af1', '5b49a8581c9ca148aec74fd49cba1e02', '441f1d3bc6664e3fb3c4342e4b721d3e', 'f8773181b96df893d354c0a132d1744f', '0', '0', '2020-03-27 16:11:20', '2020-03-27 16:11:20'), ('89b53846b0c70e1450c59a132cda07f8', 'f2e5f0598978c156186d705a1f27472e', 'c5bba1ea3d6a4759821b51162d80f6ae', '0ea804171243cfd5e75225af46e48675', '0', '0', '2020-02-26 16:01:05', '2020-02-26 16:01:05'), ('9850227927d694fe5bac32e5576d0e5e', '5b49a8581c9ca148aec74fd49cba1e02', '123', 'f8773181b96df893d354c0a132d1744f', '0', '0', '2020-03-21 15:41:34', '2020-03-21 15:41:34'), ('b7863ef910d53449c021d333ba38110d', 'f2e5f0598978c156186d705a1f27472e', 'f8738c494c9b494cb487333e76a178ce', 'b4156ef30ffc32ca81d31fc468b63c8a', '0', '0', '2020-03-02 15:51:42', '2020-03-02 15:51:42'), ('b8780f055f7b7a5b6b208067d04cca00', 'f2e5f0598978c156186d705a1f27472e', '76a6efd1b91043b7ac52b63d0e184d54', 'cb2c176f1a85249207609604bd2c7878', '0', '0', '2020-03-03 10:58:04', '2020-03-03 10:58:04'), ('c2c19e2edf75fcf186cea5f4070e6cd2', '5b49a8581c9ca148aec74fd49cba1e02', '441f1d3bc6664e3fb3c4342e4b721d3e', '3508aead54c42d26a97bf4cb46fdb1a9', '0', '0', '2020-03-27 16:11:20', '2020-03-27 16:11:20'), ('e1513b584bd8413957c0b4c67542856b', '5b49a8581c9ca148aec74fd49cba1e02', 'a2869d22ba004ee3be09843f4695c59b', '580324686581e2f31a57add5576b1377', '0', '0', '2020-02-26 00:20:26', '2020-02-26 00:20:26'), ('e56a94deb5691402ac2ac98725dccb6e', 'f2e5f0598978c156186d705a1f27472e', '096a91cd9f004b1583fe24ef89dabb7e', '0ea804171243cfd5e75225af46e48675', '0', '0', '2020-02-27 13:59:54', '2020-02-27 13:59:54'), ('eb35601d1a0d8ad6aeeb4a0d094efd75', '5b49a8581c9ca148aec74fd49cba1e02', '76a6efd1b91043b7ac52b63d0e184d54', '8f357e04b9d9829c4e1021b67ec259e7', '0', '0', '2020-03-03 14:45:52', '2020-03-03 14:45:52'), ('f36237a7c8ac32ebe906a95799e8d1a3', '5b49a8581c9ca148aec74fd49cba1e02', '3fc57a47ae6c4a25b7a5aa98ac9c8653', 'fd53c5a349e46b93ae90710bb8be1a79', '0', '0', '2020-02-26 10:38:07', '2020-02-26 10:38:07');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
